Infinity Datasource - Json Parse multiple value with Where condition

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

Checkout multiple filter here

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

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:

Here you go.

:spoon: :fishing_pole_and_fish:

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.

That did it. Thank you