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.
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.
FilterBar
Menu
CheckBox
Excel
you can change the filter type by setting
filterSettings->type
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: