Possibly covered already - need defaults for SET<STRING> parameter

There is documentation on how to provide default values for base data types, but what about providing them for a set? What is the best way to invoke something like this

CREATE QUERY zMarkTest(SET< STRING > codes)

where most of the time I have a predetermined set of codes I want to use.

You are probably thinking that I can just call it from the command line or python and provide the codes at runtime, but I would like to know how to establish defaults within the query definition. The main reason I want to use a set is so that I can use the IN predicate within the query.

MATCH = SELECT c FROM Procedures:c WHERE c.procedureCode IN codes;

thanks

I think you could possibly take in a LIST as the parameter and it would get you the desired behavior, but I haven’t done that before so I am not 100%.

1 Like