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.
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!
Our workaround here is to replace all null expiration dates with dates 1000 years from now but having nested blocks would be a superior solution.
Personally, I would prefer the same UI just with the added power to add nested blocks over an expression editor. Respectfully, the expression editor can be a bit erratic and hard to use.
I imagine something like what I suggest is more in the spirit of what Tulip wants to do. Barring a requirement that the underlying mechanics of queries would have to change, it’s also probably easier to achieve in terms of the CSS / HTML / JSON or what have you.
