Hello. I am using InfluxDB
Lets say i have a query
Select * from customMeasurements.
Now i would like to make the WHERE condition as much dynamic as possible. Is there a way how to define variables, so the user can input/select the where condition using it?
I can create variable query to get all tags from the test
SHOW TAG KEYS ON "myTestDB" FROM "customMeasurements" WHERE TestName =~ /^$testName$/
This query correctly shows all tags on selected testName ( testName is another variable )
Now since i have the list of all tags, is it possible to create variables that would allow user to determine WHERE condition?
For example the query would return tags : age, gender, eyesColor
And the user would input into variable something like “age=‘10’”
And the query would look like
Select * from customMeasurements WHERE age ='10';
if the user would input age=10;gender= male , the condition would look like:
Select * from customMeasurements WHERE age ='10' and gender='male':
and if he wouldnt input anything the query would be simply
Select * from customMeasurements
is something like this possible with grafanna?