Filtering and Searching

• Jan 04, 2024
• 2 minutes to read

The Filtering feature allows you to display a subset of records in the data source that meet the desired criteria. When filtering is applied, only data rows that meet the specified criteria are displayed. You can filter data against single or multiple columns.

Applying filtering to a column does not affect the filter settings of other columns. Column filters are combined by the AND operator into a single filter expression which is applied to the grid. The filter string works like the WHERE clause of an SQL SELECT statement.

Note

The GridControl ignores custom CellTemplates when users filter data. Use other techniques to format cell values if you want to affect filter operations.

Filtering

• Drop-down Filter
• Automatic Filter Row

• Filter Editor

• Filter Panel

• End-User Capabilities

• Filter Elements

• Predefined Filters
• Data Analysis Filters

• Conditional Formatting Filters

• Filtering in Code

• Filter Expressions
• Allowed Filters

• Filter Modes and Custom Filtering

• TreeListView Filter Modes

Searching

• Search
• Incremental Search

Examples

• How to: Apply a Custom Filter Condition
• How to: Customize Filter Items in a Column’s Drop-Down Filter
• How to: Create a Custom Drop-down Filter
• How to: Specify Row Visibility in the ViewModel
• How to: Pass Filtered Data to the ViewModel
• How to: Filter Columns Bound to Collection Properties