WebFilter.Criteria Property

Gets or sets the filter expression.

Namespace: DevExpress.Web.ASPxPivotGrid.Data

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

NuGet Package: DevExpress.Web

Declaration

C#

[DefaultValue(null)]
public CriteriaOperator Criteria { get; set; }

VB.NET

<DefaultValue(Nothing)>
Public Property Criteria As CriteriaOperator

Property Value

Type	Default	Description
CriteriaOperator	null	A CriteriaOperator descendant that represents the filter expression.

Remarks

You can assign the filter expression to the Criteria property. Another way is to set a filter expression as a string and assign it to the CriteriaString property.

The code snippet below shows how to apply filters in two ways:

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)
      );
}

Note

The filter expression is not supported in OLAP mode.