ColumnView.ClearColumnsFilter() Method

Removes any filter conditions applied to the View’s columns.

Namespace: DevExpress.XtraGrid.Views.Base

Assembly: DevExpress.XtraGrid.v20.2.dll

NuGet Package: DevExpress.Win.Grid

Declaration

C#

public virtual void ClearColumnsFilter()

VB.NET

Public Overridable Sub ClearColumnsFilter

Remarks

The ClearColumnsFilter method clears the filter conditions applied to the View’s columns.

If the filter criteria only needs to be temporarily disabled set the ColumnView.ActiveFilterEnabled property to false. To get the current filter criteria, use the ColumnView.ActiveFilter property.

Refer to the Filter and Search topic for more information.

Related GitHub Examples

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

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-hide-certain-records-in-the-xtragrids-detail-views-e684/CS/Form1.cs#L52

GridView detailView = (sender as GridView).GetDetailView(e.RowHandle, e.RelationIndex) as GridView;
detailView.ClearColumnsFilter();
detailView.Columns["EmployeeID"].FilterInfo = new DevExpress.XtraGrid.Columns.ColumnFilterInfo(3, "3");

how-to-open-a-columns-filter-list-via-the-keyboard-e894/CS/Form1.cs#L133

if(e.KeyCode == Keys.X) {
    view.ClearColumnsFilter();
    e.Handled = true;

VB.NET

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

Dim detailView As GridView = TryCast((TryCast(sender, GridView)).GetDetailView(e.RowHandle, e.RelationIndex), GridView)
detailView.ClearColumnsFilter()
detailView.Columns("EmployeeID").FilterInfo = New DevExpress.XtraGrid.Columns.ColumnFilterInfo(3, "3")

how-to-open-a-columns-filter-list-via-the-keyboard-e894/VB/Form1.vb#L128

If e.KeyCode = Keys.X Then
    view.ClearColumnsFilter()
    e.Handled = True