When template doesnt return any value , Mysql query is throwing an error

Grafana Plugin Development
1

When i use template variable in the mysql query which doesnt return any value .
it throws error from mysql .
Is there any way i can resolve this issue .

error:“Error 1064: 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 ‘) and Interface_Name in () and Kafka_Topic in()’ at line 5”

2

You should be able to use a custom null/empty value in template variable. Please try that.

Marcus

3

Thanks Mefraimsson :slight_smile:

It worked for me .