Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [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]Getting Started
   [Expand]Binding to Data
   [Expand]Grid View
   [Expand]View Technology
   [Expand]Grouping
   [Expand]Sorting
   [Expand]Summaries
   [Expand]Data Editing
   [Expand]Filtering and Locating Rows
   [Expand]Focus and Selection Handling
   [Expand]Processing Rows
   [Expand]Formatting Cell Values
   [Expand]Master-Detail Relationships
   [Expand]Asynchronous Image Load
   [Expand]Export and Printing
   [Expand]Appearance and Conditional Formatting
   [Expand]Batch Modifications
   [Expand]Hit Information
   [Expand]Hints
   [Expand]Popup Menus
   [Expand]Saving and Restoring Layouts
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]Examples
   [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]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[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

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

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