Filtering and Searching

• Sep 17, 2021

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 any other column. Column filters are combined by the AND operator into a single filter expression which is applied to the grid. The filter string can be considered to be the WHERE clause of an SQL SELECT statement.

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 within a Column’s Filter Dropdown
• How to: Create a Custom Filter Dropdown
• How to: Specify Row Visibility in the ViewModel