Multi-Value Variable PostgreSQL

[millaw]

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

Kind regards, Milla

[jangaraj]

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

This and other good tips are mentioned in the doc http://docs.grafana.org/features/datasources/postgres/

[millaw]

Thanks a lot for your help!