Selecting by variables in Influx data source

Grafana v9.4.7

I would like to search for metrics by collection qa1,qa2,qa3,qa4 etc. but when I set qa1 it shows me qa10-19

i made a variable
SHOW TAG VALUES FROM “solr7” WITH KEY=collection WHERE solr=‘true’
Query WHERE collection =~ /^$qa/

and despite this, instead of the metric for qa1, it still displays for qa1 and qa10-19
qa10_products, qa11_addresses,qa11_related_products, qa12_addresses
I would like it to work properly :frowning:

Hi @damianfrankow0101 ,
Try using next regex in your query for dashboard variable:

^qa\d+$

Dashboard variable should show those values to choose:

qa1
qa2
...
qa9
qa10
qa11
...
qa18
qa19

but won’t show (because regex don’t match them):

qa10_products
qa11_addresses
qa11_related_products
qa12_addresses

 

Complete query should look like this:

 

Let me know if this helps. P.S. You can always check your regex on regex101 website.

 

Best regards,
ldrascic