I am trying to use %INLIST in SQL query using a cursor and the query fails to return results. It appears that the variable I use against %INLIST returns an empty string. All the examples I have seen use result sets and build the query as a string. Is it possible to use %INLIST in a cursor-based query? Below is a a snippet of the code I am using:
Property mylist as %String (MAXLEN="") [InitialExpression = "route1, route2, route3"];
set routeList = $LISTBUILD(mylist)
&sql(DECLARE MyReport CURSOR FOR
SELECT
ProcessStartDate,