What we kind of already did with grafana-studio.js and Improve Kiosk-mode display in our context already is also something which resonates with others in general, see How To Customize elements in dashboard page - Support - Grafana Community.
Sometimes, we had to SQL-CAST variables into Strings (VARCHAR) as we thought it would be obligatory for Grafana.
Like that.
SELECT osm_country_code, state_and_city, name_and_id, sensor_type_name
FROM irceline_network
WHERE
station_id IN ($irceline_station_id) AND
CAST (sensor_type_id AS VARCHAR) IN ($irceline_station_sensortype)
ORDER BY osm_country_code, state_and_city, name_and_id, sensor_type_name;
which would yield
SELECT osm_country_code, state_and_city, name_and_id, sensor_type_name
FROM irceline_network
WHERE
station_id IN ('1234','1118') AND
CAST (sensor_type_id AS VARCHAR) IN ('482','20','391','71','10','4013','431','464','8','38','7','5','6002','6001','62106','1','62101','21','61102','61110')
ORDER BY osm_country_code, state_and_city, name_and_id, sensor_type_name;
However, we just found through Using Variables to dynamically select Columns in MySQL - Support - Grafana Community that multi-value variables can be rendered/formatted without quoting each single value, see also Variables | Grafana Documentation.
This works like a charm, we tried it by using ${irceline_station_id:csv} and ${irceline_station_sensortype:csv} in the following query.
SELECT osm_country_code, state_and_city, name_and_id, sensor_type_name
FROM irceline_network
WHERE
station_id IN (${irceline_station_id:csv}) AND
sensor_type_id IN (${irceline_station_sensortype:csv})
ORDER BY osm_country_code, state_and_city, name_and_id, sensor_type_name;
SELECT osm_country_code, state_and_city, name_and_id, sensor_type_name
FROM irceline_network
WHERE
station_id IN (1234,1118) AND
sensor_type_id IN (482,20,391,71,10,4013,431,464,8,38,7,5,6002,6001,62106,1,62101,21,61102,61110)
ORDER BY osm_country_code, state_and_city, name_and_id, sensor_type_name;
at places where they are not yet possible. Here: Worldmap Panel again.
Q: Is this of interest for us?
Interesting things at Grafana. Ping, @wtf.
Didn’t get into the details what this is exactly all about, yet. However, this came from an answer to one of our ramblings.