Infinity Datasource - Json Parse multiple value with Where condition

Grafana Dashboards
1

Hello,

I’m currently using UQL with infinity datasource to filter values based on another variable.

parse-json
| where "workspace_name" == '$workspace'
| project "deployment_name"

This works great with single value on workspace variable. How can I extend the above so it works with multi values from workspace variable?

Regards

2

Checkout multiple filter here

https://grafana.github.io/grafana-infinity-datasource/docs/filters

3

Thank you for the reply. That looks like what I need. But I’m clearly too dumb to apply it.

how would the multi filter work with the example I posted in the original example?

parse-json
| where "workspace_name" in (${workspace:singlequote})
| project "Deployment_name"

Above does not return anything, no idea what singlequote is suppose to be
Apologies for requesting to be spoon fed :smiley:

4

Here you go.

:spoon: :fishing_pole_and_fish:

5

Hi @ctpeacar

Instead of the where expression, I use a jsonata expression like this:

parse-json
 | jsonata "*[`workspace_name` in [${workspace:singlequote}]]"
 | project "Deployment_name"

where the variable you created is called workspace. Pay attention to the syntax above!

The above works for multiple value variables in my UQL using jsonata.

2 Likes
6

That did it. Thank you

1 Like