Having trouble getting nested variables to work together

[ameflorenti]

I believe this has been replied here:

Using multi-value variable with "All" option with PostgresSQL

I am using Grafana 8.0.6 in combination with PostgreSQL. I created a variable, with the options: “multi-value” and “include all option”. The recommended way 1 is to use an “IN” clause to filter for this variable, like so: SELECT hostname FROM host WHERE region IN($region) Under the hood however, “all” actually lists all elements. Assuming the example from above, having regions a,b,c, the SQL statement would expand to: SELECT hostname FROM host WHERE region IN('a', 'b', 'c') That may actua…

For your case it should be:

SELECT t.column1 FROM table t  WHERE  t.column2= ANY(ARRAY[$variable]::varchar[])