WebPrefilter.Criteria Property

Gets or sets the Prefilter‘s expression.

Namespace: DevExpress.Web.ASPxPivotGrid.Data

Assembly: DevExpress.Web.ASPxPivotGrid.v18.2.dll

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 Prefilter‘s expression.

Remarks

Use the Criteria property to obtain the Prefilter‘s current expression. You can also use this property to specify the filter expression in code.

C#

protected void Page_Load(object sender, EventArgs e) {
    if(!IsPostBack && !IsCallback)
        ASPxPivotGrid1.Prefilter.Criteria =
              CriteriaOperator.Parse("fieldOrderYear = 1995 AND fieldOrderQuarter between (2, 4)");
}

Note

The Prefilter is not supported in OLAP mode.