[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Chart Control
  [Expand]Pivot Grid
  [Expand]Rich Text Editor
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Collapse]Query Builder
   [Expand]Getting Started
    Binding to Data
    Selecting Tables
    Joining Tables
   [Collapse]Shaping Data
     Data Sorting
     Data Grouping and Aggregation
     Data Filtering
    Previewing Results
    Obtaining the Resulting Query
    Localizing the Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[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)

Data Filtering

The Query Builder allows you to specify filter criteria to only display the required result set.

Expanded Filter Data

Click an empty space on the design surface to display the Query Properties panel, and in the invoked panel, click the Filter property's ellipsis button.

This opens the Filter Editor which provides a visual interface for constructing filter criteria with an unlimited number of filter conditions combined by logical operators.

A filter condition consists of three parts:

  • A data source field;
  • A criteria operator, such as Equals, Is less than, Is between, etc;
  • A static operand value or another data field.

You can arrange specific conditions into groups with And, Or, Not And, and Not Or operators.

In the advanced mode, the Filter Editor enables you to type a filter string manually. You can find a list of all available operators and functions and learn the criteria syntax in the Criteria Language Syntax topic.

Expanded Filter Groups

The Group Filter option becomes available in the Query Properties panel if you grouped your data.

Clicking this property's ellipsis button invokes the Filter Editor where you can specify filter conditions for grouped and aggregated data.

Expanded Select the Specified Number of Records

Use the Select Top property to specify the number of first records to include to the query result set. The Offset option becomes available if data is sorted. Use this option to define how many records to skip before data is retrieved.

Expanded Select Distinct Values

Set the Select distinct property to Yes to include only non-duplicated values in the query result set.

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