Regular and Checked Drop-down Filters

• Apr 01, 2021
• 3 minutes to read

A regular drop-down filter allows end users to select one item at a time. To use this filter for a column, set the column’s ColumnBase.FilterPopupMode property to List.

A checked drop-down filter allows end users to select several items simultaneously. To use this filter for a column, set the column’s ColumnBase.FilterPopupMode property to CheckedList.

The following table summarizes the differences between regular and checked drop-down filters:

Feature	Regular Drop-down Filter	Checked Drop-down Filter
Selection	One item at a time can be selected.	Multiple items can be selected simultaneously.
Clear filter	Click the (All) item. This cancels the current column’s filters.	Click the (Select All) item.
MRU items (most recently used items)	Yes Use the DataControlBase.AllowColumnMRUFilterList property to show/hide MRU items. Use the DataControlBase.MRUColumnFilterListCount property to specify the maximum number of MRU items.	No
(Blanks) and (Non Blanks) items	Yes (Blanks) - Displays records with DBNull values in the current column. (Non Blanks) - Displays records without DBNull values in the current column.	Yes Set DataControlBase.ImplyNullLikeEmptyStringWhenFiltering to true.
Add custom items	Yes	No
Delete individual items	Yes	Yes
Limit the number of items	Yes A drop-down filter displays all unique values in a column. Specify the ColumnBase.ColumnFilterPopupMaxRecordsCount property to limit the number of items in the drop-down filter.	Yes A drop-down filter displays all unique values in a column. Specify the ColumnBase.ColumnFilterPopupMaxRecordsCount property to limit the number of items in the drop-down filter.
Display only the records that meet the current filter criteria	Yes Set the DataControlBase.ShowAllTableValuesInFilterPopup (ColumnBase.ShowAllTableValuesInFilterPopup) property to false.	Yes Set the DataControlBase.ShowAllTableValuesInCheckedFilterPopup (ColumnBase.ShowAllTableValuesInCheckedFilterPopup) property to false.
Immediate update	Selecting an item automatically updates the column’s filter and closes the drop-down filter.	Use the ColumnBase.ImmediateUpdateColumnFilter property to enable or disable automatic updates. If automatic updates are disabled, the filter is applied after the drop-down filter is closed.
Allowed filters	If AllowedBinaryFilters.Equals is disabled, the drop-down filter hides unique values. If AllowedUnaryFilters.IsNull is disabled, the drop-down filter list hides the (Blanks) item. If AllowedUnaryFilters.IsNotNull is disabled, the drop-down filter list hides the (NotBlanks) item. The filter button is hidden if all these criteria are disabled.	For non-nullable columns: If AllowedAnyOfFilters.AnyOf is disabled, the filter button is hidden. For nullable columns: If AllowedAnyOfFilters.AnyOf is disabled and the DataControlBase.ImplyNullLikeEmptyStringWhenFiltering property is false, the filter button is hidden. If AllowedAnyOfFilters.AnyOf is disabled and the DataControlBase.ImplyNullLikeEmptyStringWhenFiltering property is true, only the (Blanks) and (All) elements are displayed. If AllowedUnaryFilters.IsNullOrEmpty is disabled and the DataControlBase.ImplyNullLikeEmptyStringWhenFiltering property is true, the (Blanks) element is hidden, and only unique values are displayed. If AllowedUnaryFilters.IsNullOrEmpty is disabled, the DataControlBase.ImplyNullLikeEmptyStringWhenFiltering property is true, AllowedAnyOfFilters.AnyOf is disabled, then the filter button is hidden. For non-nullable date-time columns when the ColumnBase.RoundDateTimeForColumnFilter is true and the ColumnBase.ColumnFilterMode is Value: If AllowedDateTimeFilters.MultipleDateRanges is disabled, the filter button is hidden. For nullable date-time columns when the ColumnBase.RoundDateTimeForColumnFilter is true and the ColumnBase.ColumnFilterMode is Value: If AllowedDateTimeFilters.MultipleDateRanges is disabled and the DataControlBase.ImplyNullLikeEmptyStringWhenFiltering property is false, the filter button is hidden. If AllowedDateTimeFilters.MultipleDateRanges is disabled and the DataControlBase.ImplyNullLikeEmptyStringWhenFiltering property is true, only the (Blanks) and (All) elements are displayed. If AllowedUnaryFilters.IsNullOrEmpty is disabled and the DataControlBase.ImplyNullLikeEmptyStringWhenFiltering property is true, only unique values are displayed. If AllowedUnaryFilters.IsNullOrEmpty is disabled, the DataControlBase.ImplyNullLikeEmptyStringWhenFiltering property is true, AllowedDateTimeFilters.MultipleDateRanges is disabled, then the filter button is hidden.