How to apply an “OR” filter in Dashboard / Low-Code App queries?

65 views
1
0 Comments

Hi everyone,

I am working with queries in Dashboards/Low-Code Apps and I need to filter a property using an "OR" condition (e.g., selecting Element 1 OR Element 2).

Currently, I am using the regex option to filter multiple elements (matching Element 1 or Element 2), but I find it can be unreliable at times.

What I would really like to do is use a standard option, like contains, and type something along the lines of Element 1 OR Element 2. Does anyone know if there is a specific syntax supported for this, or what the correct way to handle this scenario is without relying on Regex?

Thanks for your help!

Wout Mahieu [SLC] [DevOps Catalyst] Answered question

1 Answer

0
11.87K 0 Comments

Hi Lucía,

A regex filter used to be the only way to achieve OR filtering behavior in a query. With DataMiner 10.6.6, we have added 2 new filter methods: 'Is one of' & 'Is none of'. These 2 new filter methods might be what you are looking for, they allow configuring a list of values where at least one should exactly match or not match the cell value (so not a contains).

Note that these methods will only be available when using the GQI DxM.

Wout Mahieu [SLC] [DevOps Catalyst] Edited answer