-
What Grafana version and what operating system are you using?
Grafana v11.6.0 in a Desktop Docker container on Windows
Backend is InfluxDB v3 Core -
What are you trying to achieve?
Building a dashboard from data in databases of InfluxDB v3 Core -
How are you trying to achieve it?
Using builder to create a SQL Query that filters using “contains”
-
What happened?
Grafana fails to put double quotes around the column name in the SQL query, producing an error that it does not recognize the field name
-
What did you expect to happen?
I expected double quotes around the field name in the WHERE clause of the SQL query, which is what happens if you select == instead of “contains”. See what happens when you select == instead:
-
Can you copy/paste the configuration(s) that you are having problems with?
Above -
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
flightsql: rpc error: code = InvalidArgument desc = Error while planning query: Schema error: No field named devicename. Valid fields are presence.“deviceId”, presence.“deviceName”, presence.“hubName”, presence.time, presence.unit, presence.value, presence.“valueBinary”. -
Did you follow any online instructions? If so, what is the URL?
No
