Where query Grafana

Grafana
1

Hallo there,

how can i filter exactly string on grafana query with influxdb for example, WHERE (“box” =~ /node-1/), but the probllem it shows me more like node-1 , node-1100 , node-1110. i want only node-1

thanks

2

Looks like you might need to try making your regex match more strict. You could try:

WHERE (“box” =~ /^node-1$/)

This will strictly match node-1 rather than any string that contains node-1.

1 Like
3

Try:
where box = ‘node-1’

Antony.

4

it doesn’t work, the problem is that in the “box” attribute include like:
apps/node-1/file/
apps/node-1100/file/
apps/node-110/file/
apps/node-1500/file/

how can i selet only the String with the node-1 ?

thanks
Moaz