Regular and Checked Drop-down Filters
- 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 Data Use the Data | 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 Data |
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 Column | Yes A drop-down filter displays all unique values in a column. Specify the Column |
Display only the records that meet the current filter criteria | Yes Set the Data | Yes Set the Data |
Immediate update | Selecting an item automatically updates the column’s filter and closes the drop-down filter. | Use the Column |
Allowed filters | If Allowed If Allowed If Allowed The filter button is hidden if all these criteria are disabled. | For non-nullable columns:
For nullable columns:
For non-nullable date-time columns when the Column
For nullable date-time columns when the Column
|