ContextQMD
Back to Devexpress

Allowed Filters

wpf-120494-controls-and-libraries-data-grid-filtering-and-searching-filtering-in-code-allowed-filters.md

latest4.2 KB
Original Source

Allowed Filters

  • Jan 17, 2025
  • 2 minutes to read

You can use the following properties to specify the available filters in the drop-down filter, filter editor, and filter row:

PropertyDescription
ColumnBase.AllowedUnaryFiltersGets or sets unary filters that the GridControl‘s column supports.
ColumnBase.AllowedBinaryFiltersGets or sets binary filters that the GridControl‘s column supports.
ColumnBase.AllowedAnyOfFiltersGets or sets any of filters that the GridControl‘s column supports.
ColumnBase.AllowedDateTimeFiltersGets or sets date-time filters that the GridControl‘s column supports.
ColumnBase.AllowedBetweenFiltersGets or sets between filters that the GridControl‘s column supports.
ColumnBase.AllowedDataAnalysisFiltersGets or sets data analysis filters that the GridControl‘s column supports.
DataViewBase.AllowedGroupFiltersGets or sets group filters that the GridControl supports.
ColumnBase.AllowedAggregateFiltersGets or sets aggregate filters that the GridControl column supports.
ColumnBase.AllowedFormatConditionFiltersGets or sets whether the GridControl‘s column supports conditional formatting filters.

Since the type of the above mentioned properties is a nullable flagged enum, you can specify allowed filters for a specific column as follows:

xaml
<dxg:GridColumn ... AllowedBinaryFilters="BeginsWith,EndsWith,Equals"/>

The default value is null. If the GridControl is bound to a virtual source, all filters are disabled.

When all filters are disabled:

Usage Notes