WebPrefilter.CriteriaString Property

Gets or sets the Prefilter‘s filter string.

Namespace: DevExpress.Web.ASPxPivotGrid.Data

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

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

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the CriteriaString property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-change-the-prefilters-filter-criteria-in-code-e1869/CS/ASPxPivotGrid_ChangingPrefilterCriteria/Default.aspx.cs#L7

protected void Page_Load(object sender, EventArgs e) {
    ASPxPivotGrid1.Prefilter.CriteriaString = "[" + fieldCountry.PrefilterColumnName +
        "] == 'UK' OR [" + fieldCountry.PrefilterColumnName + "] == 'USA'";

VB.NET

how-to-change-the-prefilters-filter-criteria-in-code-e1869/VB/ASPxPivotGrid_ChangingPrefilterCriteria/Default.aspx.vb#L9

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
    ASPxPivotGrid1.Prefilter.CriteriaString = "[" & fieldCountry.PrefilterColumnName & "] == 'UK' OR [" & fieldCountry.PrefilterColumnName & "] == 'USA'"
End Sub