Postgresql like multiple values manual#
Postgresql like multiple values code#
Postgresql like multiple values free#

I checked the “Advanced variable format options” with the hope that “advanced” options should have a format for the most common data query language which is SQL. Grafana colorful charts are now less appealing when we get an non-user-friendly message like this.

Postgresql like multiple values manual#

This is an invalid SQL syntax and gets, in PostgreSQL: pq: syntax error at or near “)”, MySQL would show: You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1, Oracle would show: ORA-00936: missing expression, SQL Server would show: Incorrect syntax near ‘)’. And I see no option in Grafana variables to disable this possibility. This is what I get when the user selects nothing. Select * from cities where country_id in ()

This is what I get when the user selects some countries,and this again is correct. Select * from cities where country_id in ('BEL','NLD','LUX') This is what I have when the user selects “All” and that’s correct. I’ll show the query generated for the different user combinations Select * from cities where country_id in ($mylist)

Now, let’s try to use this variable, that I called “mylist” for the demo, in a SQL statement: So I’ve created the Grafana variable with this query, and selected “Multi-value” and “Include All option” to let the user chose any combination:

Postgresql like multiple values code#

I alias my columns with “_value” and “_text” to show the country name to the user but get the country code from what she selected. Select country_id _value, name _text from countries order by 2

My goal is to get something like that where I can choose one, many, all or no country at all:

Postgresql like multiple values free#

The problem to solve: IN() list in SQL from a multi-value variableįor this example I’ve created a PostgreSQL database in Google Cloud SQL, loaded sample data from Gerald Venzl and a free grafana cloud service. However, when I find a workaround, I publish it to help others and hopefully find someone who has a better solution, so please leave a comment if what I do there is completely silly. Yes, Grafana is nice but is very far from what I can do with Excel in 5 minutes. And I’m actually spending more time in finding workarounds than solving problems.

When I have a problem, I find the solution (blog posts, forums, mailing lists, support notes)… But with modern software, the first problems I encounter have a dead end in unresolved git issues. I’m working for years with technology that works. If you want to build a dashboard for your boss, or put it on a large screen in the open space, that’s beautiful. Pros: it is really nice, I mean aesthetically.