Grafana: Template Variables: Unterschied zwischen den Versionen
Aus Wiki-WebPerfect
Admin (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „ == InfluxDB: "SHOW TAG VALUES" does not support a WHERE time clause == === Issue === If you use a InfluxDB Query "SHOW TAG VALUES" it returns all possible va…“) |
Admin (Diskussion | Beiträge) |
||
| Zeile 1: | Zeile 1: | ||
| − | + | = Troubleshooting = | |
| − | + | ||
== InfluxDB: "SHOW TAG VALUES" does not support a WHERE time clause == | == InfluxDB: "SHOW TAG VALUES" does not support a WHERE time clause == | ||
=== Issue === | === Issue === | ||
Version vom 18. Mai 2020, 14:32 Uhr
Inhaltsverzeichnis
Troubleshooting
InfluxDB: "SHOW TAG VALUES" does not support a WHERE time clause
Issue
If you use a InfluxDB Query "SHOW TAG VALUES" it returns all possible values instead of the one present in the time period selected. There is a open GitHub "Feature Request": https://github.com/influxdata/influxdb/issues/5668
Workaround "Subquery"
SELECT "host" FROM (SELECT "<value>", "host" FROM "<InfluxDB>" WHERE $timeFilter)
host = is the tag I want to limit by time
value = is a Influx FieldKey (just needs to contain any value)
