[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand].NET Core 3 Support
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Implementation Details
   [Expand]Views
   [Expand]Grid View Data Layout
   [Expand]Binding to Data
   [Expand]Master-Detail Data Representation
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Filtering and Searching
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Paging and Scrolling
   [Expand]Focus, Navigation, Selection
   [Expand]Drag-and-Drop
   [Expand]Conditional Formatting
   [Expand]Appearance Customization
   [Expand]MVVM Enhancements
   [Expand]Printing and Exporting
   [Expand]End-User Interaction
   [Expand]Miscellaneous
   [Expand]Performance Improvement
   [Expand]Design-Time Features
   [Collapse]Visual Elements
    [Collapse]Common Elements
      Data Column
      Automatic Filter Row
      Column Filter Dropdown
      Column Band Chooser
      Band Column
      Bands Panel
      Column Header Panel
      Grid Header
      Data Navigator
      Filter Panel
      MRU Filter List
      Search Panel
      Group Footer
      Group Panel
      Group Row
      New Item Row
      Summary Panel
      Footer Cell
      Cell Tooltip
      Fixed Summary Panel
      Edit Form
      Compact Panel
    [Expand]Table View Elements
    [Expand]Card View Elements
    [Expand]TreeList View Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Filter Panel

The Filter Panel is automatically shown at the bottom of the View, after a filter has been applied. Removing the filter hides this panel. The Filter Panel displays a string which represents the current filter criteria, and contains buttons to disable/enable and clear the filter. To make this panel always visible or always hidden, use the DataViewBase.ShowFilterPanelMode property.

The Filter Panel displays the following elements:

  • Filter Expression

    Column filters are combined by the And operator into a single filter expression which is applied to a View. The filter string can be considered to be the WHERE clause of a SQL SELECT statement. To obtain the filter string applied to a View, use the DataControlBase.FilterString property.

  • Enable/Disable Filter

    End-users can use this check box to enable/disable the current filter.

    You can enable/disable the current filter in code by setting the DataControlBase.IsFilterEnabled property .

  • Edit Filter

    Invokes the Filter Editor.

    The Edit Filter button is hidden if the GridControl is bound to a virtual source. Set the DataViewBase.AllowFilterEditor property to true to show this button.

  • Clear Filter

    Clears the current filter.

The table below lists the main properties affecting element behavior and appearance:

Characteristics

Members

Visibility

DataViewBase.ShowFilterPanelMode

Contents

DataViewBase.FilterPanelText, DataViewBase.ShowEditFilterButton

DataViewBase.CustomFilterDisplayText

The text displayed within the Filter Panel, is returned by the DataViewBase.FilterPanelText property. To provide your own text that describes the grid's filter, handle the DataViewBase.CustomFilterDisplayText event.

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