Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Collapse]Tree List
   [Expand]Product Information
   [Collapse]Concepts
    [Expand]Binding to Data
    [Expand]Data Representation Basics
    [Expand]Data Editing
    [Collapse]Data Shaping and Manipulation
     [Expand]Data Summaries
     [Expand]Sorting
     [Collapse]Filtering
       Filtering in Code
       Filter Row
       Filter Control
       Search Panel
       Header Filter
     Drag and Drop
    [Expand]Focus and Navigation
     Appearance Customization
     Save and Restore Layout
    [Expand]Templates
     Toolbars
   [Expand]Visual Elements
   [Expand]Examples
   [Expand]Member Tables
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [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]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Filtering

Expanded Overview

Filtering allows you to display a subset of records that meet certain criteria in the data source. When filtering is applied, the ASPxTreeList displays only data nodes that meet the specified criteria. Data nodes can be filtered against a single or multiple data columns.

The ASPxTreeList allows filtering its data nodes by column values or displaying text using the column's TreeListDataColumn.FilterMode property. Filtering by display text is ignored in database server mode.

End-users can build simple filter criteria and apply it using the Filter Row or the column's Header Filter.

A filter condition uses comparison operators the column's TreeListDataColumn.AutoFilterCondition property specifies. End-users can select the filter condition using the context menu, which is invoked by clicking a filter row button. The following eleven operators are available:

  • Begins with
  • Contains
  • Doesn't contain
  • Ends with
  • Equals
  • Is greater than
  • Is greater than or equal to
  • Is less than
  • Is less than or equal to
  • Doesn't equal
  • Like ('%', '_')

Complex filter expressions can be applied in code or using the Filter Control invoked by clicking the Filter Bar. Use the TreeListSettings.ShowFilterBar option to control the filter bar's visibility.

Note

In virtual mode, the ASPxTreeList's filtering mechanism is not applied to child nodes whose parent nodes are collapsed.

Expanded Concepts

Expanded Member Table

Expanded Online Demos

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