How to make an OR filter in GQI query?

Solved256 viewsGQI Filter GQI queries
0
0 Comments

I would like to filter on Dom data using an OR operation on one of the Dom columns.
For example a Column “Status”.
So far I found that the GQI query filter uses an AND operation.

How could I make an Filter to show all rows where “Status” = “New” OR “In Progress”?
Should I use flows for this?
I would also like to keep the number of queries executed to my datasource (database) to a minimum.

Any suggestions?

Mieke Dryepondt [SLC] [DevOps Advocate] Selected answer as best 27th January 2025

1 Answer

5
7.69K 1 Comment

Hi Mieke,

If this column is a string column, you can use a regex filter method to act as an ‘OR’ filter. Other than this workaround, there are no ‘OR’ conditions in GQI.

Mieke Dryepondt [SLC] [DevOps Advocate] Posted new comment 27th January 2025
Mieke Dryepondt [SLC] [DevOps Advocate] commented

Wout, this is exactly what I need! you are the best.