Table Quires: Combination of 'Any' and 'All' conditions

It would be helpful to have the more flexibility with filtering options in the interactive tables and table queries. Sometime we need to have a queries that look for records of a combination of ‘all’ and ‘any’ conditions. For example: Field1 = A & Field2 = B &( Field3 = Z or Field3 = X). It would be useful if this was something that was natively possible and would not require additional queries/logic to implement a workaround.

Possibly the addition of an expression style editor to configure these filters would make it very simple to create and display more complex query filter logic.

Hey @lpascoe, thanks for reaching out about this!

Allowing to use the expression editor for more complex filter logic - similar to how this can be done in triggers - is a great idea. There is currently no related work on our roadmap. But we’ll take this into consideration for future planning!

Hi, what is you workaround here? Can you provide any examples?

I`m facing the same issue.