Hey! I am using postgres and dropdown list with 4 values in it to filter query results. When I choose parameters from those 4 one by one separately it works perfectly value = ‘{{Filter_Name}}’; however when I choose couple of them together and change sql snippet to value in ‘{{Filter_Name}}’ , there are no results of query . When I write value in (value1,value2,value3,value4) It works well. Could You please suggest what is a possible issue here?
Looks like your SQL is malformed. You need to replace your single-quotes with parentheses.
WHERE value in ( {{ Filter_Name }} )
1 Like