CODEWITHSUNDEEP
influxdb
Danielius Polujanskis
Danielius Polujanskis

Reputation: 29

InfluxDB query and filter values

cant seem to find if similar post. I am using Grafana / InfluxDB I am trying to create a variable in Grafana, to create this variable I need to query values which I can do easily with this piece:

SHOW TAG VALUES WITH KEY = "name"

However, I need to filter the values that I get, in example, I would like only to see values that have specific url maybe just https://google.com.

I tried something like this

SHOW TAG VALUES WITH KEY = "name" WHERE "name" = 'https://google.com'

And I get only on instance of this URL, perhaps there is a way to find all the URL's which contain https://google.com

Upvotes: 0

Views: 438

Answers (1)

Jan Garaj
Jan Garaj

Reputation: 28626

Try regular expressions, probably:

SHOW TAG VALUES WITH KEY = "name" 
WHERE "name" =~ /.https:\/\/google\.com./

Upvotes: 1

Related Questions