Filters


In order to filter the data in Infinity datasource, you can use the following options based on the parser you are using.

Note: All these filtering will happen after retrieving the content. For better performance, use the filtering at your API

Filtering with Backend Parser#

When using the backend parser, use the following examples for filtering your data. In most cases you will be filtering data based on single value or multiple value variable.

Variable setup - single
Variable setup - multi
Without filter
With single filter
With multi filter
With multi filter (NOT IN)
imageimage

Filtering with UQL Parser#

When using the backend parser, use the following examples for filtering your data. In most cases you will be filtering data based on single value or multiple value variable.

Without filter
With single filter
With single filter (JSONata)
With multi filter
Multi filter (JSONata)
Multi filter (NOT IN)
Multi filter (NOT IN) (JSONata)
parse-json
| summarize count("name") by "region"