Advanced Filters

DeeboData implements the most advanced filtering capabilities a data grid can really offer right out of the box. You don't even need to configure anything beyond the quick start for your language or framework. Let's review DeeboData's default rules for how columns of each respective data type can be filtered differently. And we'll also go over the code that executes the filtering logic so you can see how it works under the hood and customize it if you like.

* You can filter by multiple columns at the same time!

Review the code that makes this work by searching your code for the implementation of nLevelFilter or columnFilter These respective functions are where the filtering logic is executed for each column and where you can customize the filtering logic if you like.

Strings

Columns whose data is alphanumeric with many distinct values can be filtered using a free text input. You can search by multiple comparisons besides equality. Just use the button to the right of the search input for that column. See all comparison types below:

Filter by not equals, empty, contains & more

Drop-down Filter (Strings)

To review DeeboData's drop-down filter rules for your language/framework of choice, please visit the appropriate link below:

Javascript

Angular

React

Numbers

Columns whose data is numeric (or null) can be filtered using the number input in the column header. Obviously, the comparisons that make sense for numbers are different than those that make sense for strings. Use the button beside the filter to get a list of the different comparisons you can use for numbers. See all comparison types below:

Filter by not equal, less than, greater than & more

Dates

Columns whose data is date/time can be filtered using the date input in the column header. See the date picker that works out of the box on the left and all date comparison types below on the right: