GridViewDataColumnSettings.AutoFilterCondition Property

Specifies the type of comparison operator used by filter row to create filter conditions for the current column.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v23.1.dll

NuGet Package: DevExpress.Web

Declaration

C#

[DefaultValue(AutoFilterCondition.Default)]
public AutoFilterCondition AutoFilterCondition { get; set; }

VB.NET

<DefaultValue(AutoFilterCondition.Default)>
Public Property AutoFilterCondition As AutoFilterCondition

Property Value

Type	Default	Description
AutoFilterCondition	Default	An AutoFilterCondition enumeration value that specifies the comparison operator type.

Available values:

Show 12 items

Name	Description
Default	For the string columns and columns that are filtered by display text - the same as the BeginsWith value. For other columns - the Equals value.
BeginsWith	Selects records whose values in the corresponding colum begin with the entered value.
EndsWith	Selects records whose values in the corresponding colum end with the entered value.
Contains	Selects records whose values in the corresponding colum contain the entered value.
DoesNotContain	Selects records whose values in the corresponding colum don’t contain the entered value.
Equals	Selects records whose values in the corresponding column match the entered value.
Less	Selects records whose values in the corresponding column are less than the entered value.
LessOrEqual	Selects records whose values in the corresponding column are less than or equal to the entered value.
Greater	Selects records whose values in the corresponding column are greater than the entered value.
GreaterOrEqual	Selects records whose values in the corresponding column are greater than or equal to the entered value.
NotEqual	Selects records whose values in the corresponding column are not equal to the entered value.
Like	Selects records whose values in the corresponding column match the entered mask. Two wildcard symbols are supported: ‘%’ substitutes zero or more characters; ‘_’ substitutes a single character.

Property Paths

You can access this nested property as listed below:

Object Type	Path to AutoFilterCondition
GridViewDataColumn	.Settings .AutoFilterCondition

Remarks

When an end user types text in the filter row‘s cell or when the ASPxGridView.AutoFilterByColumn method is called, a filter condition is created based upon the value entered. This filter is then applied to the ASPxGridView. The comparison operator used in this filter condition is determined by the column’s AutoFilterCondition property.

If the AutoFilterCondition property is set to Default, the column’s comparison operator type is controlled by the ASPxGridView’s ASPxGridViewSettings.AutoFilterCondition property.

Example

The following example illustrates how to use the AutoFilterCondition property.

Web Forms approach:

Note

For a full example, see the ASPxGridView - Customization Dialog demo.

ASPX

<dx:ASPxGridView ID="Grid" runat="server" DataSourceID="ProductsDataSource" 
    EnableRowsCache="false" Width="100%">
    <Columns>
        <dx:GridViewDataTextColumn FieldName="ProductName">
            <Settings AutoFilterCondition="Contains" />
        </dx:GridViewDataTextColumn>
        <dx:GridViewDataComboBoxColumn FieldName="CategoryID" Caption="Category Name" SortIndex="0" SortOrder="Ascending" AdaptivePriority="1">
            <PropertiesComboBox DataSourceID="CategoriesDataSource" ValueField="CategoryID" TextField="CategoryName" ValueType="System.Int32" />
            <Settings AllowHeaderFilter="True" AllowAutoFilter="False" SortMode="DisplayText" />
            <SettingsHeaderFilter Mode="CheckedList" />
        </dx:GridViewDataComboBoxColumn>
        ...
    </Columns>
</dx:ASPxGridView>

MVC approach:

Note

For a full example, see the GridView - Customization Dialog demo.

Razor

@Html.DevExpress().GridView(settings => {
    settings.Name = "GridView";
    settings.SettingsCustomizationDialog.Enabled = true;
    ...
    settings.Columns.Add(c => {
        c.FieldName = "ProductName";
        c.Settings.AutoFilterCondition = AutoFilterCondition.Contains;
    });
    settings.Columns.Add(c => {
        c.FieldName = "CategoryID";
        c.Caption = "Category Name";
        c.SortIndex = 0;
        c.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
        c.AdaptivePriority = 1;
        c.Settings.AllowHeaderFilter = DefaultBoolean.True;
        c.Settings.AllowAutoFilter = DefaultBoolean.False;
        c.Settings.SortMode = DevExpress.XtraGrid.ColumnSortMode.DisplayText;
        c.SettingsHeaderFilter.Mode = GridHeaderFilterMode.CheckedList;
        c.EditorProperties().ComboBox(cb => {
            cb.DataSource = NorthwindDataProvider.GetCategories();
            cb.TextField = "CategoryName";
            cb.ValueField = "CategoryID";
            cb.ValueType = typeof(int);
        });
    });
}).Bind(Model).GetHtml()