Column Filters are filters that are applied to the data at the column level. Many Column Filters can be active at once (e.g. filters set on different columns) and the grid will display rows that pass every column's filter.
Column Filters are accessed in the grid UI either through the Column Menu or the Tool Panel.
Column Filter Types
You can use the Provided Filters that come with the grid, or you can build your own Filter Components if you want to customise the filter experience to your application.
There are four main Provided Filters, plus the Multi Filter. These are as follows:
- Text Filter - A filter for string comparisons.
- Number Filter - A filter for number comparisons.
- Date Filter - A filter for date comparisons.
- A filter influenced by how filters work in Microsoft Excel. This is an AG Grid Enterprise feature.
- Allows for two filters to be used together (either one of the above Provided Filters or a Custom Filter Component). This is an AG Grid Enterprise feature.
Example: Provided Filters
The example below demonstrates the four Provided Filters and the Multi Filter:
- Column Athlete has a Text Filter.
- Column Age has a Number Filter.
- Column Date has a Date Filter.
- Column Country has a Set Filter.
- Column Sport has a Multi Filter (consisting of a Text Filter and a Set Filter).
Relation to Quick Filter and External Filter
Column Filters work independently of Quick Filter and External Filter. If Quick Filter and / or an external filter are applied along with a Column Filter, each filter type is considered and the row will only show if it passes all three types.
Column Filters are tied to a specific column. Quick Filter and external filter are not tied to any particular column. This section of the documentation talks about Column Filters only. For Quick Filter and external filter, click the links above to learn more.
Continue to the next section to learn about Text Filters.