WebPrefilter.CriteriaString Property

Gets or sets the Prefilter‘s filter string.

Namespace: DevExpress.Web.ASPxPivotGrid.Data

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

NuGet Package: DevExpress.Web

Declaration

C#

[DefaultValue("")]
public string CriteriaString { get; set; }

VB.NET

<DefaultValue("")>
Public Property CriteriaString As String

Property Value

Type	Default	Description
String	String.Empty	A String value that specifies the Prefilter‘s filter string.

Remarks

The Prefilter‘s expression can also be specified via the WebPrefilter.Criteria property.

C#

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