go to post Kyle Wagner · Dec 3, 2018 The %INLIST predicate is meant to be used against properties of type %List. Your property is defined as a %String that happens to contain a delimited string of values.SQLCODE should have contained an error code when you attempt to fetch the cursor (-400).To do what your trying to do you could either use the %CONTAINS predicate IE: "...AND routeList %CONTAINS (RouteName)"Or you could convert the string to a list. This would convert your delimited string property to a %List, allowing %INLIST to function correctly.IE: RouteName %INLIST($LISTFROMSTRING(routeList))Best solution would probably be to convert the property to %List if possible or even another table.Hope that helps!