GridColumn.FilterInfo Property

Gets or sets the filter condition applied to the column.

Namespace: DevExpress.XtraGrid.Columns

Assembly: DevExpress.XtraGrid.v19.2.dll

Declaration

C#

[Browsable(false)]
public ColumnFilterInfo FilterInfo { get; set; }

VB.NET

<Browsable(False)>
Public Property FilterInfo As ColumnFilterInfo

Property Value

Type	Description
ColumnFilterInfo	A ColumnFilterInfo object specifying the filter condition applied to the column.

Remarks

To apply a filter to a column, assign a ColumnFilterInfo object to the FilterInfo property. You can assign a single ColumnFilterInfo object to multiple columns at once.

To clear a column’s filter specified by the FilterInfo object, call the GridColumn.ClearFilter method.

The following example shows how to assign filter criteria (“[ShipCountry] = ‘Poland’”) to the CustomerID grid column.

C#

GridColumn columnCustomer = gridView1.Columns["CustomerID"];
columnCustomer.FilterInfo = new ColumnFilterInfo("[ShipCountry] = 'Poland'");

VB.NET

Dim columnCustomer As GridColumn = GridView1.Columns("CustomerID")
columnCustomer.FilterInfo = New ColumnFilterInfo("[ShipCountry] = 'Poland'")

See Filter and Search for more information.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the FilterInfo 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-add-a-custom-filter-item-into-the-date-filter-popup-e5172/CS/MyDateFilterPopup.cs#L89

if(customCheck.Checked) {
    ColumnFilterInfo cfi = Column.FilterInfo;
    View.ShowCustomFilterDialog(Column);

how-to-create-a-custom-filter-for-a-date-column-e610/CS/WindowsApplication1/Form1.cs#L50

    ColumnFilterInfo dateFilter = new ColumnFilterInfo(binaryFilter.ToString(), filterDisplayText);
    gridView1.Columns["Date"].FilterInfo = dateFilter;
}

how-to-hide-certain-records-in-the-xtragrids-detail-views-e684/CS/Form1.cs#L53

    detailView.ClearColumnsFilter();
    detailView.Columns["EmployeeID"].FilterInfo = new DevExpress.XtraGrid.Columns.ColumnFilterInfo(3, "3");
}

how-to-filter-grid-columns-using-separate-checkedlistboxcontrols-t124162/CS/Form1.cs#L53

    filterString = String.Join(" Or ", items);
    gridView1.Columns[fieldName].FilterInfo = new DevExpress.XtraGrid.Columns.ColumnFilterInfo(filterString);
}

how-to-edit-data-displayed-within-the-dashboard-t289951/CS/Dashboard_EditData/UnderlyingDataForm.cs#L31

    ColumnFilterInfo filterInfo = new ColumnFilterInfo(new InOperator(columnName, filterList));
    orderIdColumn.FilterInfo = filterInfo;
}

VB.NET

how-to-add-a-custom-filter-item-into-the-date-filter-popup-e5172/VB/MyDateFilterPopup.vb#L106

If customCheck.Checked Then
    Dim cfi As ColumnFilterInfo = Column.FilterInfo
    View.ShowCustomFilterDialog(Column)

how-to-create-a-custom-filter-for-a-date-column-e610/VB/WindowsApplication1/Form1.vb#L57

    Dim dateFilter As New ColumnFilterInfo(binaryFilter.ToString(), filterDisplayText)
    gridView1.Columns("Date").FilterInfo = dateFilter
End Sub

how-to-hide-certain-records-in-the-xtragrids-detail-views-e684/VB/Form1.vb#L47

    detailView.ClearColumnsFilter()
    detailView.Columns("EmployeeID").FilterInfo = New DevExpress.XtraGrid.Columns.ColumnFilterInfo(3, "3")
End Sub

how-to-filter-grid-columns-using-separate-checkedlistboxcontrols-t124162/VB/Form1.vb#L46

    filterString = String.Join(" Or ", items)
    gridView1.Columns(fieldName).FilterInfo = New DevExpress.XtraGrid.Columns.ColumnFilterInfo(filterString)
End Sub

how-to-edit-data-displayed-within-the-dashboard-t289951/VB/Dashboard_EditData/UnderlyingDataForm.vb#L32

    Dim filterInfo As New ColumnFilterInfo(New InOperator(columnName, filterList))
    orderIdColumn.FilterInfo = filterInfo
End Sub