We use InfluxDB tags as variables in Grafana and we would like to limit tags by time range selected there.
Using $timeFrame is supported for select InfluxDB queries but tags are returned by "SHOW TAGS" which doesn't support $timeFrame: https://github.com/influxdata/influxdb/issues/5668
Select can return tags only in case you return value as well and as a result, you have an array which is not supported in Grafana:
Does anyone know any workaround how to get tags based on time range?
Found workaround using select, subquery and distinct:
select DISTINCT("name") from (select "name","value" from "http_req_duration" WHERE $timeFilter AND "group" =~ /^$Group$/ AND "TestName" =~ /^$TestName$/)
I'm sure will be useful for others.