[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Collapse]Grid View
   [Expand]Product Information
    Getting Started
    [Expand]Binding to Data
    [Expand]Data Representation Basics
    [Expand]Focus and Navigation
    [Expand]Data Editing
    [Collapse]Data Shaping and Manipulation
     [Expand]Data Summaries
       Filtering in Code
       Filter Row
       Filter Control
       Header Filter
       Search Panel
      Cell Merging
    [Expand]Data Formatting
    [Expand]Master-Detail Relationship
     Appearance Customization
    ASPxGridView Designer
   [Expand]Visual Elements
   [Expand]Member Tables
   [Expand]ASPxGridView - Animated Images
  [Expand]Tree List
  [Expand]Card View
  [Expand]Chart Control
  [Expand]Pivot Grid
  [Expand]Rich Text Editor
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Filter Row

The Filter Row allows end-users to filter grid data by typing text directly into the row. To display the Filter Row at the top of the ASPxGridView, set the ASPxGridViewSettings.ShowFilterRow property to true.

Use the ASPxGridViewBehaviorSettings.FilterRowMode property to specify the Filter Row mode:

  • Auto - The grid automatically applies the filter text typed by an end-user in the filter row. The filter is applied after 1200 milliseconds. To change this time interval between the time the user starts typing within the Filter Row and when filtering is applied, use the ASPxGridViewBehaviorSettings.AutoFilterRowInputDelay property.

  • OnClick - The filter is applied when the user clicks Apply.

The applied filter criteria are displayed in the filter bar that is hidden.. To change this default setting and display the filter bar, set the ASPxGridSettings.ShowFilterBar property to true. Handle the ASPxGridBase.CustomFilterExpressionDisplayText event to display custom text within the filter bar. The filter expression applied to the grid can be accessed using the ASPxGridBase.FilterExpression property.

Use the ASPxGridViewSettings.ShowFilterRowMenu property to control the visibility of filter row buttons that allow end-users to select filter criteria from the drop-down filter row menu.

Expanded The 'Like' Filter Row Menu Item

The filter row menu can display the Like menu item. Use the following properties to specify its visibility.

The Like item allows end-users to create filter expressions using the following wildcard masks.

  • The '%' symbol - substitutes zero or more characters.
  • The '_' symbol - substitutes a single character.

The Like menu item's tooltip displays the help text that explains which wildcard masks are supported. See Criteria Language Syntax to learn more.

Expanded Auto Filter Row Cell Editors

Filter row cells use the same editors that are used to edit grid cells values. ASPxGridView allows you to replace these default editors with custom ones using the ASPxGridView.AutoFilterCellEditorCreate event.

This event is raised for each cell within the filter row. The event parameter provides the Column property (which identifies the processed filter row cell) and the Value property (which returns the processed cell's value). To replace the settings used to create the default editor, create the EditPropertiesBase descendant, and assign it to the event parameter's EditorProperties property.

Handle the ASPxGridView.AutoFilterCellEditorInitialize event to initialize filter row cell editors (default and/or custom). This event is raised before the ASPxGridView displays the filter row.

Is this topic helpful?​​​​​​​