[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Collapse]Data Grid
   [Expand]Get Started With Data Grid and Views
   [Expand]Data Binding
    Unbound Columns
   [Expand]Data Editing and Validation
   [Expand]Filter and Search
   [Expand]Focus and Selection Handling
    Format Cell Values
   [Expand]Master-Detail Relationships
   [Expand]Asynchronous Image Load
   [Expand]Export and Printing
   [Expand]Appearance and Conditional Formatting
    Split Presentation
    Row Preview Sections
   [Expand]Batch Modifications
    Hit Information
    Popup Menus
   [Expand]Save and Restore Layout
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Collapse]End-User Capabilities
     End-User Capabilities: Data Editing
     End-User Capabilities: Locating Rows Using Incremental Search
     End-User Capabilities: Controlling the Visibility of Columns, Bands and Card Fields
     End-User Capabilities: Navigating Through Rows and Cells
     End-User Capabilities: Rearranging Columns, Bands and Card Fields
     End-User Capabilities: Resizing Columns and Bands
     End-User Capabilities: Resizing Cards
     End-User Capabilities: Selecting Rows/Cards
     End-User Capabilities: Expanding and Collapsing Rows and Cards
     End-User Capabilities: Sorting
     End-User Capabilities: Grouping
     End-User Capabilities: Filtering
     End-User Capabilities: Filter Editor
     End-User Capabilities: Filter Editor - Building Filter Criteria
     End-User Capabilities: Applying Summaries
     End-User Capabilities: Locating Rows Using Search (Find) Panel
    Included Components
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[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)

End-User Capabilities: Filtering

Expanded Create a Simple Filter Condition

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

  1. Invoke the filter dropdown list containing available filter values. See below on how to do this.

    By default, if filtering is applied, the filter dropdown will only display the values that match the current filter criteria. If the SHIFT key is pressed while opening the filter dropdown, all values will be listed (not only those that match the current filter criteria).

  2. Select the required filter value in the filter dropdown list.

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

    If the filter dropdown list provides check boxes to the left of 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 using the method described above.

Expanded Create Complex Filter Criteria

To construct filter criteria involving multiple columns/card fields, and using various comparison operators, do one of the following.

  • Invoke the filter dropdown list (see below) and click Custom. This will invoke the Custom Filter Dialog, allowing you to compare a column with one or two values:

  • Use the Filter Builder that allows complex filter criteria to be constructed. See End-User Capabilities: Filter Editor to learn more.

Expanded Clear the Filter

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

  • Invoke the filter dropdown list (see below) and click (All).
  • In Grid Views, right-click the column header and select Clear Filter.

To clear the total filter criteria, click the Close Filter button within the Filter Panel.

Expanded Disable/Enable the Filter

Click the Enable Filter button within the Filter Panel.

Expanded Invoke the Filter Dropdown List

  • In Grid Views, hover over the column header. Click the filter button () within the column header that appears.

  • In Card Views, click the Customize button and then click the Filter button corresponding to the target column.

  • In Layout Views, hover over the target card field within any card. Click the filter button () that appears.

Expanded See Also

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