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
  [Collapse]Vertical Grid
   [Expand]Overview
   [Expand]Fundamentals
   [Collapse]Concepts
     Filtering
    [Expand]Layouts
    [Expand]Binding to Data
    [Expand]Rows
    [Expand]Records
    [Expand]Cells
    [Expand]In-place Editors
     Formatting
    [Expand]Appearances
     Hit Information
    [Expand]Custom Painting
    [Expand]Alpha Blending and Background Images
    [Expand]Customization Form
     Batch Modifications
    [Expand]Drag and Drop
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]Examples
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Pivot Grid
  [Expand]Tree List
  [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]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

The Vertical Grid control supports filtering that allows it to only display a part of data that meet particular criteria. Data can be filtered against single or multiple grid rows (fields in the data source), using a simple or complex criterion for each filtered row. End-users can apply filtering using Filter Dropdowns in row headers, or build a filter in the Filter Editor.

Expanded Filter Dropdowns

An end-user can invoke the Filter Dropdown by clicking the Filter Buttons in the row header. The Filter Dropdown contains a list of available data values for the current row and provides predefined filters based on the row's data type.

Filtering is enabled in the Vertical Grid control by default. You can disable filtering for the whole control or a particular row using the VGridOptionsFilter.AllowFilter and VGridOptionsRowFilter.AllowFilter properties, respectively. If filtering is disabled, the filter buttons are hidden, and data cannot be filtered.

A row's Filter Dropdown only contains data values that meet filter criteria already applied to other rows, by default. Pressing SHIFT while clicking the filter button in the row header shows all the available data values. However, you can specify that the control always displays all the available data values by enabling the VGridOptionsFilter.ShowAllValuesInFilterPopup option.

Expanded Filter Panel

Once a filter is applied to data, the Filter Panel is displayed.

The Filter Panel is only displayed when a filter is applied, and automatically hides otherwise (by default). You can specify that the Panel is always or never visible using the VGridOptionsView.ShowFilterPanelMode property.

The main purpose of the Filter Panel is to indicate which filter is currently applied. You can customize the filter's textual representation by handling the VGridControl.CustomFilterDisplayText event.

The drop-down button in the Filter Panel invokes a list of recently applied filters. You can disable this functionality or limit the number of items in the list (the default is 7) using the VGridOptionsFilter.AllowMRUFilterList and VGridOptionsFilter.MRUFilterListPopupCount options.

Clicking on the "Edit Filter" button invokes the Filter Editor which allows an end-user to create a filter. The Editor provides the visual (the default) and text views. The VGridOptionsFilter.DefaultFilterEditorView option allows you to override the default view.

The result is shown below.

Expanded See Also

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