Skip to main content

ColumnViewOptionsFilter.ShowAllTableValuesInFilterPopup Property

Gets or sets whether filter dropdown lists must display unique values from all the records in the View’s data source or only from those records that meet the current filter criteria. This option is in effect for regular and Excel-style Filter Dropdowns.

Namespace: DevExpress.XtraGrid.Views.Base

Assembly: DevExpress.XtraGrid.v23.2.dll

NuGet Packages: DevExpress.Win.Grid, DevExpress.Win.Navigation

Declaration

[DefaultValue(false)]
[XtraSerializableProperty]
public virtual bool ShowAllTableValuesInFilterPopup { get; set; }

Property Value

Type Default Description
Boolean false

true if filter dropdowns should contain unique values from all the records in the View’s data source; false if the filter dropdowns of unfiltered columns should contain unique values only from the records that meet the current filter criteria.

Property Paths

You can access this nested property as listed below:

Object Type Path to ShowAllTableValuesInFilterPopup
ColumnView
.OptionsFilter .ShowAllTableValuesInFilterPopup

Remarks

The filter dropdown of a filtered column will always contain unique values from all the records in the data source regardless of the ShowAllTableValuesInFilterPopup property’s setting. Thus if this option is set to false it affects only the filter dropdowns of the unfiltered columns.

Note that the filter dropdowns of an unfiltered column will contain unique values from all the records in the data source regardless of the ShowAllTableValuesInFilterPopup property’s value if an end-user holds the SHIFT key down while clicking the filter button.

The contents of individual filter dropdowns can be customized by handling the ColumnView.ShowFilterPopupListBox event.

The ShowAllTableValuesInFilterPopup option is in effect for regular filter dropdown lists. The ColumnViewOptionsFilter.ShowAllTableValuesInCheckedFilterPopup property has the same meaning, but it is applied to checked filter dropdown lists.

For detailed information about filtering, see the Filter and Search and Filter and Search topics.

See Also