Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Reporting
  [Expand]Chart Control
  [Collapse]Grid View
   [Expand]Product Information
    Getting Started
   [Expand]Fundamentals
   [Collapse]Concepts
    [Expand]Binding to Data
    [Expand]Data Representation Basics
    [Expand]Focus and Navigation
    [Expand]Data Editing
    [Collapse]Data Shaping and Manipulation
     [Expand]Data Summaries
     [Collapse]Filtering
       Filtering in Code
       Filter Row
       Filter Control
       Header Filter
       Search Panel
     [Expand]Grouping
     [Expand]Sorting
      Cell Merging
    [Expand]Data Formatting
    [Expand]Master-Detail Relationship
     Appearance Customization
     Adaptivity
     Save and Restore Layout
    [Expand]Templates
    [Expand]Export
     Toolbars
    [Expand]ASPxGridLookup
    ASPxGridView Designer
   [Expand]Visual Elements
   [Expand]Examples
   [Expand]Member Tables
   [Expand]ASPxGridView - Animated Images
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [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]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Filter Row

If the ASPxGridViewSettings.ShowFilterRow property is set to true, the Filter Row is displayed at the top of the ASPxGridView data rows. It allows end-users to filter data by typing text directly into the row.

The Filter Row can work in either Auto or OnClick mode based on the ASPxGridViewBehaviorSettings.FilterRowMode property value.

In Auto mode, the filter is applied on the fly, when an end-user types text within a row. By default, the filter is updated after 1200 milliseconds. To change the time interval between when a user starts typing within the Filter Row and when filtering is applied, use the ASPxGridViewBehaviorSettings.AutoFilterRowInputDelay property.

In OnClick mode, the filter is applied on the Apply button click.

You can access the applied filter expression from the ASPxGridBase.FilterExpression property.

Filter row buttons allow end-users to select filter criteria from the dropdown filter row menu. The visibility of the buttons is controlled by the ASPxGridViewSettings.ShowFilterRowMenu property.

The applied filter criteria are displayed in the filter bar. It is hidden by default, and can be displayed by setting the ASPxGridSettings.ShowFilterBar property to true. You can display custom text within the filter bar by handling the ASPxGridBase.CustomFilterExpressionDisplayText event.

Expanded The 'Like' Filter Row Menu Item

The filter row menu can display the Like menu item. The availability of this menu item is controlled by the following properties:

The Like item allows end-users to create filter expressions with the following wildcards:

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

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

Expanded Auto Filter Row Cell Editors

By default, editors used to edit cell values within the filter row are the same as the editors used to edit values of corresponding columns. ASPxGridView allows these default editors to be replaced with custom editors. To do this, handle 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.

To initialize cell editors (default and/or custom) displayed within the filter row, handle the ASPxGridView.AutoFilterCellEditorInitialize event. This event is raised before the filter row is displayed within ASPxGridView.

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