Grafana variable regex returns no results when using MongoDB source

Question

I am creating a variable in Grafana from a mongoDB query. Currently my query returns an array of items in the format of:

name="Bob Hansen", id="8051240138eb2ea033aa21f3"
name="John Doe", id="4051240138eb2ea033aa21f3"
...

I have the following regex:

/name="(?<text>[^"]+)|id="(?<value>[^"]+)/g

But grafana keeps returning no values, unless I remove the regex :(

markalex · Accepted Answer · 2023-10-03 19:44:18Z

0

You shouldn't use alteration.

Alteration in your regex means, that once first branch is matched, second part is not checked.

Correct expression for this case will be

name="(?<text>[^"]+)", id="(?<value>[^"]+)

Demo here.

answered Oct 3, 2023 at 19:44

markalex

13.9k3 gold badges15 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1