ColumnBase.AllowColumnFiltering Property

Gets or sets whether an end user can filter data by column. This is a dependency property.

Namespace: DevExpress.Xpf.Grid

Assembly: DevExpress.Xpf.Grid.v19.1.Core.dll

Declaration

C#

public DefaultBoolean AllowColumnFiltering { get; set; }

VB.NET

Public Property AllowColumnFiltering As DefaultBoolean

Property Value

Type	Description
DefaultBoolean	A DefaultBoolean enumeration value that specifies whether an end user can filter data by column.

Available values:

Name	Description
True	Corresponds to a Boolean value of true.
False	Corresponds to a Boolean value of false.
Default	The value is determined by the current object’s parent object setting (e.g., a control setting).

Remarks

The GridControl allows end users to filter data if the DataViewBase.AllowColumnFiltering property is set to true.

Individual columns provide the AllowColumnFiltering property, allowing the default behavior specified by the view, to be overridden. Setting this property to true or false overrides the default behavior. This can be useful when it is required to prevent an end user from invoking the filter dropdown of individual columns:

Xaml

<dxg:GridControl.Columns>
    <dxg:GridColumn FieldName="OID" Header="Id" />
    <dxg:GridColumn FieldName="From" />
    <dxg:GridColumn FieldName="AnimationElement" 
                    UnboundType="Object" 
                    Visible="False" 
                    ShowInColumnChooser="False" 
                    AllowColumnFiltering="False" />
</dxg:GridControl.Columns>

Note

The AllowColumnFiltering property does not affect the availability Automatic Filter Row. To control the availability of Automatic Filter Row, use the ColumnBase.AllowAutoFilter property.

If the AllowColumnFiltering property is set to Default, the ability to filter data is controlled by the view’s DataViewBase.AllowColumnFiltering property. In this case, use the ColumnBase.ActualAllowColumnFiltering property to get whether an end-user can filter data by the current column.

Tip

Topic: Drop-down Filter

Tip

Demo: Filtering

Requires installation of WPF Subscription. Download

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the AllowColumnFiltering property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-customize-the-merge-field-collection-and-perform-mail-merge-using-the-ilist-data-so-t532297/CS/SimpleDataMerge/CustomizeMergeFieldsControl.xaml#L29

<dxg:GridControl.Columns>
    <dxg:GridColumn Name="gridColumn1" Header="Data field name (readonly)" MinWidth="155" AllowAutoFilter="False" AllowColumnFiltering="False" AllowEditing="False" AllowMoving="False" AllowSorting="False" FieldName="Name" ShowInColumnChooser="False" />
    <dxg:GridColumn Name="gridColumn2" AllowAutoFilter="False" MinWidth="100" AllowColumnFiltering="False" AllowMoving="False" AllowSorting="False" Header="Display name" FieldName="DisplayName" />

how-to-bind-to-custom-service-with-restrictions/CS/MainWindow.xaml#L26

            AllowedDateTimeFilters="SingleDateRange" FilterPopupMode="DateSmart"
            AllowColumnFiltering="{DXBinding '$dxu:DefaultBooleanExtension.ToDefaultBoolean(!@e(hotColumn).IsSorted and !@e(weekColumn).IsSorted)'}">
<dxg:GridColumn.EditSettings>

how-to-zoom-an-image-that-is-placed-in-the-dxgrid-cell-e1721/CS/WpfApplication1/WpfApplication1/Window1.xaml#L16

<dxg:GridColumn FieldName="CategoryName" />
<dxg:GridColumn FieldName="Picture" AllowColumnFiltering="False">
    <dxg:GridColumn.CellTemplate>

how-to-parallelize-data-intensive-operations-on-in-memory-data-in-instant-feedback-ui-mode-e3382/VB/MainWindow.xaml#L15

<dxg:GridControl.Columns>
    <dxg:GridColumn x:Name="colOrderId" FieldName="OrderId" Header="ID" Width="60" MinWidth="60" AllowColumnFiltering="False" AllowGrouping="False" />
    <dxg:GridColumn x:Name="colCustomerName" FieldName="CustomerName" Width="200" />

how-to-implement-a-custom-inline-edit-form-for-dxgrid-e4798/VB/DXGrid.CustomDropdownRowEditor/MainWindow.xaml#L19

<dxg:GridControl.Columns>
    <dxg:GridColumn Header="#" Width="40" AllowMoving="False" AllowResizing="False" FixedWidth="True" AllowColumnFiltering="False" HorizontalHeaderContentAlignment="Center">
        <dxg:GridColumn.CellTemplate>