Better numeric filtering

When filtering on a field containing a numeric value, the only numeric comparison options appear to be: Equals(=), Does not equal(!=), Greater than(>), and Less than(<).

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)

1 Like

Hey @dkonigs! That’s a great suggestion, we will discuss your feature idea with the team and I’ll update you afterwards. Thanks :raised_hands:

Hey again @dkonigs! We plan to introduce condition groups, and with that functionality, you will be able to use advanced filtering combining AND & OR. Here is the issue to track the progress: Condition groups: advanced filtering combining AND & OR (#1271) · Issues · Bram Wiepjes / baserow · GitLab.

2 Likes