Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]Controls and Libraries
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
   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
     Filtering Overview
     Automatic Filter Row
     Filter Dropdown
     Filter Editor
     Filter Modes and Custom Filtering
     Filtering in Code
     Filter Expressions
     Search Panel
     Incremental Search
     Filtering Nodes
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Data Scrolling
   [Expand]Focus and Navigation
   [Expand]Conditional Formatting
   [Expand]Drag and Drop Overview
   [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]Scheduler (new)
  [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]Diagram Control
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[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 on the fly by typing text directly into the row. When an end-user types the text within the row, a filter condition is automatically created based upon the values entered and applied to the column.

By default, the auto-filter row is hidden. It can be activated by setting the TableView.ShowAutoFilterRow property to true.

By default, when an end-user modifies the text within the auto filter row's cell, the filter condition for this column is immediately updated. To disable automatic updates, set the column's ColumnBase.ImmediateUpdateAutoFilter property to false. In this instance, an end-user should press the Enter key or move focus to another cell to force the updates.

To remove the filter, clear the text from the auto-filter row.

Note

When the ColumnBase.ShowCriteriaInAutoFilterRow property is set to True, the GridControl does not take into account the ColumnBase.AutoFilterCondition property value. Instead, it uses the ColumnBase.AutoFilterCriteria property. So, to apply the required condition, use the ColumnBase.AutoFilterCriteria property.

Expanded Auto-Filter Row Settings

  • Availability

    Columns provide the ColumnBase.AllowAutoFilter property that specifies whether their values can be filtered using the automatic filter row. If this property is set to false, the corresponding cell within the automatic filter row is disabled.

  • Comparison Operator Type

    A column's ColumnBase.AutoFilterCondition property allows you to specify the comparison operator type (CONTAINS, EQUALS or LIKE).

  • Identifier

    The automatic filter row is identified by its handle, returned by the static DataControlBase.AutoFilterRowHandle field.

  • Row Data

    A cell's value can be obtained using the corresponding column's ColumnBase.AutoFilterValue property.

  • Filter Criteria Selector

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

  • Applying Filter Criteria

    • Filter Row Delay

      You can specify the filter delay time in milliseconds using the DataViewBase.FilterRowDelay property. The following example shows how to create a grid control that delays column filtering by 1 second.

    • Filter Condition Update Mode

      By default the filter condition is updated each time the user modifies text in the auto filter row. You can set the column's ColumnBase.ImmediateUpdateAutoFilter to false to disable automatic updating. This way the filter criteria will be applied when an end-user presses the Enter key or moves the focus to another cell.

How would you rate this topic?​​​​​​​