How to filter out some values of grafana dashboard variable?

Question

I have such a variable but it returns some values which I don't want to see(template0 and template1)

How can I filter them out ?

I tried to write label_values(datname!~"template.*|postgres")

But grafana says that this definition has broken syntax

iamlucas · Answer 1 · 2022-10-17T09:23:19.607

2

try to improve the query as follows

label_values({datname=~".+", datname!~"template.*|postgres"}, datname)

Hope this helps!

edited Oct 17 '22 at 09:23

answered Oct 17 '22 at 08:19

iamlucas

unofrtunately it filters all values except ALL – gstackoverflow Oct 17 '22 at 08:40
can you please provide the metric which we are filtering ? – iamlucas Oct 17 '22 at 08:50
It is cross metric value ` label_values(label) Returns a list of label values for the label in every metric. ` https://grafana.com/docs/grafana/latest/datasources/prometheus/#query-variable – gstackoverflow Oct 17 '22 at 08:54
Okay now i understand. Try this: label_values({datname=~".+", datname!~"template.*|postgres"}, datname) also edited my answer – iamlucas Oct 17 '22 at 09:22

score 1 · Accepted Answer · answered Oct 17 '22 at 09:04

1

This works(filter both: postgres and tempate database):

answered Oct 17 '22 at 09:04

gstackoverflow

2 Answers2