HOME

Example of Filter Menu in ASP.NET Core Data Grid Control

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.

DEMO

SOURCE

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.

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:

Not Equal
Does Not Start With
Does Not End With
Does Not Contain
Empty
Not Empty
Like

Number and Date type columns:

Null
Not Null

For example, when the Like search operator is used:

%a% - Filters words containing the character 'a'
a% - Filters words ending with 'a'
%a - Filters words starting with 'a'

In this demo, filter menu is enabled by default. You can switch to other filter types using the dropdown.

FilterMenu

Example of Filter Menu in ASP.NET Core Data Grid Control