Can't seem to pass a list of values to an in statement. Only get first value.
parameter @List as text
criteria in([@List])
tried "val1" , "val2", "val3" and 'val1', 'val2', 'val3' and val1, val2, val3
best result was returned val1 from query
in design window I can use in("val1", "val2", "val3") but not in(
[List])