Error with dashboard variables parameters (Multi-value, Include All option)

Grafana Dashboards
1

What happened:
Our team has its own graph deployed on. In its functionality, I ran into a problem: the parameters do not work in the dashboard variable: (screenshot in the attachment).
In my opinion, the Multi-value parameter is not parsed, since if you select one element, the request works, and the Include All option parameter does not work completely, since when you select it, the panel freezes and is not updated.

How to reproduce it (as minimally and precisely as possible):
Versions of grafana and druid I set below. I use druid sql syntax to print data (screenshot in the attachment).

Environment:

  • Grafana version: grafana-enterprise:9.0.0-beta3, grafana:latest, grafana:main
  • Data source type & version: druid 0.22.1
  • OS Grafana is installed on: linux
  • User OS & Browser: Safari
  • Grafana plugins: grafadruid-druid-datasource
sql query used:
SELECT
  __time as "time",
  name as "service",
  count(sla) as " "
FROM SYTESTER_DRUID
WHERE name in ('${service}')
AND __time >= MILLIS_TO_TIMESTAMP(${__from}) AND __time <= MILLIS_TO_TIMESTAMP(${__to})
GROUP BY __time, name

I call variable ā€œserviceā€ in look like ā€˜$serviceā€™ and ā€˜${service}ā€™. I received the same error in both cases.

Maybe I make something wrong?

It does not allow to me upload images in this topic(((

1 Like
2

Hi @nikitaelmanov

I donā€™t know if you are doing something wrong, but I can say that the implementation for tmeplate variables is data-source plugin specific.

Looks like you are using a community plugin, so it might be worth making an issue over in that repo:

3

looks like that repo hasnā€™t seen much recent developmentā€¦

4

"WHERE something IN($my_variable) " works (at least with postgresql). I had exact same issues as you described until I used this syntax. Immediately mulitple function and all function were working fine.