The DevExpress ASP.NET MVC GridView provides a powerful data filtering mechanism that displays a dropdown list of all unique values within a column. End-users can easily filter the grid records by selecting the values displayed within the dropdown. The dropdwon can be invoked by a click on a column header’s filter button.
Additionally, end-users can filter items by entering text in the filter editor above the list. When typing a filter string, the header filter items list is automatically updated, so only the relevant items that match the filter string are displayed.
Header filter dropdown buttons are disabled by default. You can display filter buttons either for for all columns (by enabling the grid's Settings.ShowHeaderFilterButton property) or for individual columns (by enabling a column's AllowHeaderFilter property).
You can specify the header filter mode for a column using the SettingsHeaderFilter.Mode property.
- In List mode, the column's header filter dropdown displays a regular list of filter items, allowing end-users to select single value.
- In CheckedList mode, the column's header filter dropdown contains a check box list, allowing end-users to select multiple values for the filter criteria.
- DateRangeCalendar and DateRangePicker modes are available for date columns only. You can take a look at these modes in the Date Range Header Filter demo.
The GridView allows you to create custom filter values, define filter criteria and display these values within the column's filter dropdown. To do this, implement a method delegate specified by the HeaderFilterFillItems property. In this demo, custom filter values are displayed within the 'Total' and 'Quantity' columns' filter dropdowns.