Comma Separate text filter not working

comma separated text filter not working.

select location,  from `my-data-base` 
where location in ({{locations}})

type of locations is text.
it's working fine in case of single text. ex :- STAGE but not working for multiple texts.

Hi @arvind
It is not working because it's a quoted string {{locations}} becomes 'STAGE,TABLE' - if Metabase didn't do this, then you would be open to SQL injections.
You are looking for this - see the comments for workarounds for several database types: - upvote by clicking :+1: on the first post