All docs
V21.1
21.1
20.2
20.1
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

WebFilter Class

A class that provides settings for complex filters.

Namespace: DevExpress.Web.ASPxPivotGrid.Data

Assembly: DevExpress.Web.ASPxPivotGrid.v21.1.dll

Declaration

public class WebFilter :
    PivotFilterBase

The following members accept/return WebFilter objects:

Library Related API Members
ASP.NET Web Forms Controls ASPxPivotGrid.Filter
ASP.NET MVC Extensions PivotGridSettings.Filter

Remarks

Use the ASPxPivotGrid.Filter property to get access to the WebFilter object.

A filter editor enables users to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators. The resulting filter condition is combined with the field-based filter criteria by the AND Boolean operator.

The filter editor provides a set of logical operators that simplify the process of creating filters for text, numeric and date-time fields.

ASPxPivotGrid_Prefilter

To apply a filter expression in code, use the WeFilter.Criteria or WebFilter.CriteriaString property.

protected void Page_Load(object sender, EventArgs e) {
  if (!IsPostBack && !IsCallback)
    //ASPxPivotGrid1.Filter.CriteriaString = "[" + fieldOrderYear.ID + "] = 2018 AND [" + fieldOrderQuarter.ID + "] between (2, 4)";
    ASPxPivotGrid1.Filter.Criteria = 
      CriteriaOperator.And(
        new BinaryOperator(fieldOrderYear.ID, 2018, BinaryOperatorType.Equal), 
        new BetweenOperator(fieldOrderQuarter.ID, 2, 4)
      );
}

Implements

Inheritance

Object
DevExpress.Utils.Controls.DisposableObject
See Also