Multi-Value Variable PostgreSQL

Hello guys!

I use Grafana with PostgreSQL as data source. For a dashboard, I have defined a Multi-value variable named $sdtype which selects distinct values from a column called “servicedeliverytype”. I am trying to use it as part of a query: …WHERE servicedeliverytype = ($sdtype);

It properly displays a graph when I choose the variable to be just one value in the dropdown menu, but when I want it to be several values, the error: “pq: operator does not exist: character varying = record” arises. Is anyone familiar with this kind of problem and might help? I would highly appreciate :slight_smile:

Kind regards, Milla

Use the IN comparison operator rather than = to match against multiple values.

This and other good tips are mentioned in the doc

Thanks a lot for your help! :slight_smile: