This sample demonstrates filtering Grid columns using menu, checkbox, and Excel filter UI. In this sample, click the filter icon on the column header to filter a particular column. You can change the filter type on the properties panel. When Excel filter type is selected, you can sort the column using the sort option in the Excel filter dialog.
|Filter Type :|
The filtering feature enables the user to view a reduced number of records based on the filter criteria. It can be enabled by setting the
allowFiltering property to true.
Grid supports the following filter types.
Now, the following additional filter operators are incorporated with the already existing operators.
String type columns:
Number and Date type columns:
For example, when the Like search operator is used:
In this demo, filter menu is enabled by default. You can switch to other filter types using the dropdown.