I have a MYSQL query that is referenced to a template variable. When the variable returns null, the mysql query fails since the IN clause contains an empty list. How do we handle such a scenario.

Handle empty variables

vaishakefi February 7, 2020, 7:41am 3

Actually you cannot use CASE - Grafana does direct substitution on template variables. If no values are returned from variables, it ll be blank. So CASE or COALESCE can’t be used in this situation.

Handling potentially empty values in custom key value pair variables

Topic		Replies	Views
When template doesnt return any value , Mysql query is throwing an error Grafana Plugin Development	2	826	February 9, 2018
Getting an error while elasticsearch variable in my mysql query Grafana panel	9	255	March 20, 2024
Grafana should not allow empty values for variable selection to avoid template errors MSSQL templating , mssql	3	10568	October 11, 2022
Bug? I'm having an issue with grafana filters when the table is empty MySQL mysql	2	790	April 29, 2022
Handling potentially empty values in custom key value pair variables Dashboards	8	3646	June 7, 2023

Handle empty variables

Related topics