Drop-down Filter

• Sep 13, 2021

A column’s drop-down filter allows you to filter data at runtime. The drop-down filter displays a column’s unique values.

To filter data against a column, an end user should click the filter button () in a column header and select any item(s):

Availability

A user can invoke a column’s drop-down filter if the view’s DataViewBase.AllowColumnFiltering property is set to true. Grid columns contain the ColumnBase.AllowColumnFiltering property that allows you to override a view’s default behavior. You can also set a column’s ColumnBase.FilterPopupMode property to Disabled to hide the filter button from this column’s header. This option still allows users to filter this column’s data in the Filter Editor.

Drop-down Filter Modes

The drop-down filter can work in different modes. Use the ColumnBase.FilterPopupMode property to change the drop-down filter’s mode.

• Excel-style Drop-down Filter
• Regular and Checked Drop-down Filters
• Date-time Drop-down Filter
• Custom Drop-down Filter