[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].NET Core 3 Support
 [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]Filtering and Searching
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Paging and Scrolling
   [Expand]Focus, Navigation, Selection
   [Expand]Drag-and-Drop
   [Expand]Conditional Formatting
   [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
   [Collapse]End-User Capabilities
     Data Editing
     Sorting
     Grouping
     Customizing Summaries
     Sorting Group Rows by Summary
     Filtering
     Drag-and-Drop
     Showing and Hiding Columns
     Navigating Through Rows and Cells
     Selecting Rows
     Resizing Columns and Cards
     Expanding and Collapsing Cards
   [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]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Filtering

Expanded Invoke the Filter Dropdown List

In Table Views, hover over the column header. Click the filter button that appears within the column header.

In Card Views, column headers are shown by clicking the button displayed at the top-right corner.

Expanded Create a Filter Condition

To select records that contain a specific value in a specific column/card field, do the following:

  • Invoke the filter dropdown list containing available filter values.
  • Select the required filter value in the filter dropdown list:

    The filter dropdown list will be closed immediately, and the control will display the records which contain the specified value in the specified column/card field.

    If the filter dropdown list provides check boxes to the left of the filter values, multiple values can be selected (checked) simultaneously. In this mode, click Ok to close the filter dropdown list and apply the filter.

You can sequentially filter data against multiple columns.

Expanded Clear the Filter

To clear the filter applied to a column, do one of the following:

  • Invoke the filter dropdown list and click (All).
  • Right-click a column's header and select Clear Filter.
  • To clear the grid's filter, click the Close Filter button within the Filter Panel:

Expanded Disable/Enable the Filter

Toggle the checked state of the Enable Filter box displayed within the Filter Panel:

Expanded Using the Automatic Filter Row

The automatic filter row (if shown) allows end-users to filter data on the fly. To filter data, type text directly into the row. When you input text within the row, a filter condition is automatically created based upon the values entered, and applied to the column.

Expanded Using the Search Panel

The Search Panel provides an efficient way of filtering data. It supports the search syntax and the MRU search dropdown list. To invoke the Search Panel, press CTRL+F.

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