[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Implementation Details
   [Expand]Views
   [Expand]Grid View Data Layout
   [Expand]Binding to Data
   [Expand]Master-Detail Data Representation
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Selection
   [Collapse]Filtering and Searching
    [Expand]Drop-down Filter
     Automatic Filter Row
     Filter Editor
     Filter Elements
    [Expand]Filtering in Code
    [Expand]Search
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Paging and Scrolling
   [Expand]Focus and Navigation
   [Expand]Conditional Formatting
   [Expand]Drag-and-Drop
   [Expand]Appearance Customization
   [Expand]MVVM Enhancements
   [Expand]Printing and Exporting
   [Expand]End-User Interaction
   [Expand]Miscellaneous
   [Expand]Performance Improvement
   [Expand]Design-Time Features
   [Expand]Visual Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Automatic Filter Row

The automatic filter row allows end-users to filter data. An end-user should type the text within the row to apply a filter condition.

The automatic filter row is hidden. Set the TableView.ShowAutoFilterRow property to true to activate the automatic filter row.

When an end-user modifies the automatic filter row cell's text, the GridControl updates the column's filter condition immediately. Set the ColumnBase.ImmediateUpdateAutoFilter property to false to disable the column's automatic updates. In this case, to update the cell an end-user should press the Enter key or focus another cell.

Clear the automatic filter row's text to remove filters.

Note

If the ColumnBase.ShowCriteriaInAutoFilterRow property is set to true, the GridControl does not use the ColumnBase.AutoFilterCondition property. In this case, use the ColumnBase.AutoFilterCriteria property to apply the required condition.

Expanded Automatic Filter Row Settings

  • Availability

    Use the ColumnBase.AllowAutoFilter property to specify whether you can filter this column's values with the automatic filter row. The corresponding cell within the automatic filter row is disabled if this property is set to false.

  • Comparison Operator Type

    The ColumnBase.AutoFilterCondition property allows you to specify the column's comparison operator type (Contains, Equals or Like).

  • Identifier

    The automatic filter row's handle identifies this row. Use the static GridControl.AutoFilterRowHandle field to get the handle.

  • Row Data

    Use the ColumnBase.AutoFilterValue property to get or set the automatic filter row's column value.

  • Filter Criteria Selector

    Set the ColumnBase.ShowCriteriaInAutoFilterRow property to true to enable a filter criteria selector. This selector allows end-users to apply the required criteria type to the required column.

    Set the TableView.ShowCriteriaInAutoFilterRow (TreeListView.ShowCriteriaInAutoFilterRow) property to true to enable a filter criteria selector for all columns.

  • Filter Row Delay

    You can specify the filter delay time in milliseconds with the DataViewBase.FilterRowDelay property. The following code sample creates a GridControl with 1-second column filtering delay:

  • Filter Condition Update Mode

    The GridControl updates the filter condition when an end-user modifies the automatic filter row's text. You can set the ColumnBase.ImmediateUpdateAutoFilter property to false to disable the column's automatic updates. In this mode, the filter criteria is applied when an end-user presses the Enter key or focuses another cell.

Expanded Filter Criteria

A cell's filter criterion depends on the ColumnBase.AutoFilterCondition and ColumnBase.AutoFilterCriteria properties:

Note

The automatic filter row's cell is disabled when the corresponding filter criterion is removed. Refer to the Allowed Filters topic for information on how to specify the allowed filters.

The automatic filter row chooses the default filter criterion in the following order:

  1. If a cell's ColumnBase.EditSettings property is CheckEditSettings, the filter criterion is Equals. The ColumnBase.ColumnFilterMode, ColumnBase.AutoFilterCondition, and ColumnBase.AutoFilterCriteria properties are ignored.
  2. If a cell's ColumnBase.ColumnFilterMode property is DisplayText or ColumnBase.FieldType property is String, the filter criterion is BeginsWith.
  3. If a cell's ColumnBase.FieldType property is byte[], the filter criterion is IsNotNull.
  4. If a cell's ColumnBase.ShowCriteriaInAutoFilterRow property is true, the filter criterion is Equals.
  5. If a cell's ColumnBase.ShowCriteriaInAutoFilterRow property is false, the filter criterion is StartsWith.
Note

When the ColumnBase.ShowCriteriaInAutoFilterRow property is true, the filter criteria selector contains only allowed filter criteria.

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