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
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Collapse]Tree List
   [Expand]Product Information
   [Expand]Feature Center
   [Collapse]Visual Elements
     Automatic Filtering Row
     Blank Column
     Caption Panel
     Cell
     Column
     Column Button
     Column Header
     Column Header Context Menu
     Column Header Panel
     Column's Filter DropDown
     Column's Filter DropDown: Excel Style
     Customization Form
     Empty Area
     Expand Button
     Filter Button
     Filter Editor
     Filter Panel
     Find Panel
     Fixed Line
     Footer Cell
     Footer Context Menu
     Group Footer
     Node Image
     Node Indents
     Node Indicator Panel
     Preview Section
     Summary Footer
   [Expand]Design-Time Features
   [Expand]Examples
   [Expand]End User Capabilities
   [Expand]Member Tables
  [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

Column's Filter DropDown

Filter DropDown lists allow end-users to specify filter criteria for particular columns and clicking the Filter Button within the column header invokes it.

The Filter DropDown displays in a Microsoft Excel-inspired style by default, which, along with the ability to select custom values, provides predefined filters suitable for the columns' data type.

The Filter DropDown can be represented as a regular list of items (where only one item can be selected at a time), as a checked list (where multiple items can be selected/checked simultaneously), or as a calendar for date-time columns.

The table below lists the main properties that affect element appearance:

Availability

TreeListOptionsBehavior.EnableFiltering (for DevExpress installations of version 16.2 and older)
TreeListOptionsCustomization.AllowFilter (for DevExpress installations of version 17.1 and newer)

TreeListOptionsColumnFilter.AllowFilter

Filter Mode

TreeListOptionsFilter.FilterMode

Filter by Edit Value or Display Text

TreeListColumn.FilterMode

Display Mode

WindowsFormsSettings.ColumnFilterPopupMode

TreeListOptionsFilter.ColumnFilterPopupMode

TreeListOptionsColumnFilter.FilterPopupMode

Immediate Updates (for Date-Time columns

TreeListOptionsColumnFilter.ImmediateUpdatePopupDateFilter

Contents

The TreeListColumn.FilterMode property specifies whether the filter dropdown list must contain unique edit values or display values.

The TreeListOptionsFilter.ShowAllValuesInFilterPopup property specifies whether the filter dropdowns must contain unique values from all the records in a control's data source or only from those records that meet current filter criteria.

To dynamically customize regular filter dropdown lists, handle the TreeList.ShowFilterPopupListBox event. To customize checked filter dropdown lists, handle the TreeList.ShowFilterPopupCheckedListBox event.

MRU Items

TreeListOptionsFilter.AllowColumnMRUFilterList, TreeListOptionsFilter.MRUFilterListPopupCount, TreeList.MRUFilters

Height

For regular filter dropdown lists, use the TreeListOptionsFilter.ColumnFilterPopupRowCount property.

Look And Feel

TreeList.LookAndFeel

Expanded See Also

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