Condition groups: advanced filtering combining AND & OR
Designs ready for the development (v1.0): https://www.figma.com/file/7BLCLdgS2zoZ0bIUw4Ua4r/Advanced-filtering?node-id=101%3A600&t=uoOlV97NbrIW6MlY-1
Introduce condition groups to deeply customize how rows are filtered. Allow joining multiple conditions together using logical conjunctions “And” & “Or”.
The biggest glaring omission here is “greater than or equal” (>=) and “less than or equal” (<=). While I know that “show me values 18 and up” can be done with “show me greater than 17”, its just that little bit of extra annoyance and mental energy. The formula language doesn’t have this awkward limitation on operators, so I wish the filter options didn’t either.
Additionally, it would be really nice to be able to specify number ranges for a filter. (e.g. “18-65”, or “from 18 through 65” Could even go as fancy as “16-65,84-89, 102,106”) A good analogy for this would be the way a print dialog lets you specify the pages of a document to print. However, there are many ways this could be approached. (and many ways to determine whether a range is inclusive or exclusive)
Community request: https://community.baserow.io/t/better-numeric-filtering/1583