The example demonstrates the filtering capabilities of Telerik RadGrid. Filtering can be enabled/disabled using
GridTableView.AllowFilteringByColumn properties. Then each
column that supports filtering (GridBoundColumn, GridCheckBoxColumn, etc) shows
a filter box beneath the corresponding header.
User can set a filter expression based on the rules specified in the corresponding column properties:
FilterFormatString, CurrentFilterFunction, CurrentFilterValue .
After pressing the filter button (next to the filter box) the grid displays only the records matching
the filter criteria (regarding the settings of all filter boxes).
Additionally, if you set AutoPostBackOnFilter property of the corresponding column to true
you can trigger postback filter operation for Contains (for string types) and EqualTo (for numeric types)
when you type in the filter box and press [Enter]
from the keyboard.
GridDateTimeColumn supports range and time independent filtering functionality which are
controlled with the EnableRangeFiltering and EnableTimeIndependentFiltering bool properties.
Moreover, you can execute other type of filter action by setting the
CurrentFilterFunction property of the corresponding column to an internally recognized value, for example:
<telerik:GridBoundColumn DataField="ProductName" HeaderText="ProductName" CurrentFilterFunction="StartsWith" AutoPostBackOnFilter="true">
Another option is to set FilterDelay property for grid column that can be
filtered. Thus filtering operations will be executed after the delay specified
through that property elapses. For example:
<telerik:GridMaskedColumn DataField="OrderID" HeaderText="OrderID" FilterControlWidth="50px" AutoPostBackOnFilter="false" CurrentFilterFunction="EqualTo" FilterDelay="2000" ShowFilterIcon="false">
The filtering menu of Telerik RadGrid is presented by single object server-side. This way of implementation has been chosen to speed up the grid performance by merely creating one menu instance server side and cloning the instance for different columns.
The filtering menu is independent for each column in RadGrid - this means that the filtering menu options vary by the DataType of the corresponding column. Hence integer column will have one set of filter menu options (EqualTo, NotEqualTo, GreaterThan, LessThan, etc.), string column will have additional options (Contains, StartsWith. etc.) and so on.
FilterType Property of RadGrid, determines what will be type of the filtering.
The grid supports two types of filtering. In one of them the user can write a filter value and choose filter function(Contains, EqualTo, LessThan, etc.) that to be used.
In the second type of filtering, the grids shows a checkbox list with predefined values. After the user selects some values and apply the filtering, the grid will show only records that match any of the selected in the list values.
Note that the built-in filtering feature is not supported with simple data-binding
(calling DataBind()). See the Simple data binding demo from the Populating with
data section for more info about the limitations of this binding mode.