OptionsColumnFilter.FilterPopupMode Property

Gets or sets which filtering options are available in pop-up menus and how they are presented.

Namespace: DevExpress.XtraGrid.Columns

Assembly: DevExpress.XtraGrid.v19.1.dll

Declaration

C#

[DefaultValue(FilterPopupMode.Default)]
[XtraSerializableProperty]
public virtual FilterPopupMode FilterPopupMode { get; set; }

VB.NET

<DefaultValue(FilterPopupMode.Default)>
<XtraSerializableProperty>
Public Overridable Property FilterPopupMode As FilterPopupMode

Property Value

Type	Default	Description
FilterPopupMode	**Default**	A FilterPopupMode value that specifies how filtering options are presented in pop-up menus.

Available values:

Name	Description
Default	The actual display mode is determined by the View’s OptionsFilter.ColumnFilterPopupMode (ColumnViewOptionsFilter.ColumnFilterPopupMode) property. If the View’s OptionsFilter.ColumnFilterPopupMode property is set to Classic: for date-time columns, filter dropdowns are painted in FilterPopupMode.DateSmart mode; for all other columns, filter dropdowns are painted in FilterPopupMode.List mode. If the View’s OptionsFilter.ColumnFilterPopupMode property is set to Default (which is the initial value): the column filter dropdown style is determined by the WindowsFormsSettings.ColumnFilterPopupMode global setting. If the WindowsFormsSettings.ColumnFilterPopupMode property is also set to Default (which is the initial value): the Excel filter dropdown style is applied.
List	The filter dropdown is represented as a regular list of filter items. Clicking an item invokes a corresponding action, and automatically closes the dropdown.
CheckedList	The filter dropdown is represented as a checked list of filter items. In this mode, an end-user can select more than one item simultaneously. When the dropdown window is closed by clicking the OK button, the View will display those records that contain the checked values:
Date	This mode is equivalent to DateSmart regarding the appearance of the filter dropdown. The filter dropdown displays all the available check boxes, even if there is no data that falls into a corresponding date range.
DateSmart	The filter dropdown provides a built-in calendar plus check boxes to select common non-intersecting date intervals. The table below describes the available date ranges for the DateSmart and Date modes. Interval Description Beyond this year Dates that follow the current year. Later this year Dates of the current year starting from the following month. Later this month Dates of the current month that follow the next week. Next week Dates that belong to the following week. Later this week Dates of the current week starting from the day after tomorrow. Tomorrow Tomorrow. Today Today. Yesterday Yesterday. Earlier this week Dates of the current week that are prior to yesterday. Last week Dates of the previous week. Earlier this year Dates of the current year that are prior to the current month. Prior to this year Dates that are prior to the current year. If there is no underlying data that would fall into a specific date range, the corresponding check box is hidden. If all values in the date-time column are set to null, all check boxes are visible.
DateAlt	This mode is equivalent to DateSmart, but with a different set of filters: Today, This week, This month, Next month, etc. The table below describes several of the date ranges for the DateAlt mode. Interval Description Beyond Dates that belong to the month in three months time and beyond. Earlier Dates that belong to the month seven months ago and earlier.
Excel	The tabbed UI, inspired by MS Excel, that displays column values and provides filtering options most suitable for the column’s data type.

Property Paths

You can access this nested property as listed below:

Object Type	Path to FilterPopupMode
GridColumn	.OptionsFilter.FilterPopupMode
LayoutViewColumn	.OptionsFilter.FilterPopupMode
BandedGridColumn	.OptionsFilter.FilterPopupMode

Remarks

Use the following properties to specify the filter menu mode:

• for the entire application - the static WindowsFormsSettings.ColumnFilterPopupMode property.
• for a specific control = the ColumnView.OptionsFilter.ColumnFilterPopupMode property. This setting overrides the static WindowsFormsSettings.ColumnFilterPopupMode property.
• for a specific column - the GridColumn.OptionsFilter.FilterPopupMode property. This setting overrides the ColumnView.OptionsFilter.ColumnFilterPopupMode property.

C#

using DevExpress.XtraEditors;

WindowsFormsSettings.ColumnFilterPopupMode = DevExpress.XtraEditors.ColumnFilterPopupMode.Classic;
gridView1.OptionsFilter.ColumnFilterPopupMode = DevExpress.XtraGrid.Columns.ColumnFilterPopupMode.Excel;
colAddress.OptionsFilter.FilterPopupMode = DevExpress.XtraGrid.Columns.FilterPopupMode.CheckedList;
colDate.OptionsFilter.FilterPopupMode = DevExpress.XtraGrid.Columns.FilterPopupMode.Date;

VB.NET

Imports DevExpress.XtraEditors

WindowsFormsSettings.ColumnFilterPopupMode = DevExpress.XtraEditors.ColumnFilterPopupMode.Classic
gridView1.OptionsFilter.ColumnFilterPopupMode = DevExpress.XtraGrid.Columns.ColumnFilterPopupMode.Excel
colAddress.OptionsFilter.FilterPopupMode = DevExpress.XtraGrid.Columns.FilterPopupMode.CheckedList
colDate.OptionsFilter.FilterPopupMode = DevExpress.XtraGrid.Columns.FilterPopupMode.Date

Note

Classic filter menus are applied by default if you handle any of the following events:

• ColumnView.ShowFilterPopupCheckedListBox
• ColumnView.ShowFilterPopupDate
• ColumnView.ShowFilterPopupListBox

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the FilterPopupMode property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-add-a-custom-filter-item-into-the-date-filter-popup-e5172/CS/MainForm.cs#L19

if(column.ColumnType == typeof(DateTime))
    column.OptionsFilter.FilterPopupMode = FilterPopupMode.Date;
else column.OptionsFilter.FilterPopupMode = FilterPopupMode.CheckedList;

how-to-customize-the-gridviews-column-filter-dropdown-to-provide-a-custom-list-of-filters-e2169/CS/WindowsApplication1/Form1.cs#L28

    gridControl1.DataSource = dataTable;
    gridView1.Columns["Column2"].OptionsFilter.FilterPopupMode = DevExpress.XtraGrid.Columns.FilterPopupMode.List;
}

how-to-sort-columns-checked-filter-drop-down-list-e1714/CS/WindowsApplication1/E1714.cs#L43

{
    column.OptionsFilter.FilterPopupMode = FilterPopupMode.CheckedList;
}

VB.NET

how-to-add-a-custom-filter-item-into-the-date-filter-popup-e5172/VB/MainForm.vb#L21

If column.ColumnType Is GetType(DateTime) Then
    column.OptionsFilter.FilterPopupMode = FilterPopupMode.Date
Else

how-to-customize-the-gridviews-column-filter-dropdown-to-provide-a-custom-list-of-filters-e2169/VB/WindowsApplication1/Form1.vb#L30

    gridControl1.DataSource = dataTable
    gridView1.Columns("Column2").OptionsFilter.FilterPopupMode = DevExpress.XtraGrid.Columns.FilterPopupMode.List
End Sub

how-to-sort-columns-checked-filter-drop-down-list-e1714/VB/WindowsApplication1/E1714.vb#L38

For Each column As GridColumn In columnView.Columns
    column.OptionsFilter.FilterPopupMode = FilterPopupMode.CheckedList
Next column