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!

1 Like