A newer version of this page is available. Switch to the current version.

WebPrefilter.Criteria Property

Gets or sets the Prefilter's expression.

Namespace: DevExpress.Web.ASPxPivotGrid.Data

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


public CriteriaOperator Criteria { get; set; }
Public Property Criteria As CriteriaOperator

Property Value

Type Default Description


A CriteriaOperator descendant that represents the Prefilter's expression.


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

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

The Prefilter is not supported in OLAP mode.

See Also