SQL Parameter 'IN' Operator

Hi,
what do you want to achive? do you want to pre-select certain filter variables (that is not possible right now). see topic: Filter variables can´t be pre-selected

or do you want to preselect certain values in your query (without using a filter)? then the correct syntax would be:
(assuming that pet_list is your field you want to filter at?)

WHERE pet_list IN (“dog”, “cat”, “chinchilla”)

Hope that helps.
Cheers, Eva

1 Like