ASPxPivotGrid.Filter Property

Gets the filter settings.

Namespace: DevExpress.Web.ASPxPivotGrid

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

NuGet Package: DevExpress.Web

Declaration

C#

[PivotAPIMemberCategory(APICategory.RelationalSource)]
public WebFilter Filter { get; }

VB.NET

<PivotAPIMemberCategory(APICategory.RelationalSource)>
Public ReadOnly Property Filter As WebFilter

Property Value

Type	Description
WebFilter	An object that contains the filter settings.

Remarks

The Filter property provides access to the WebFilter object that contains filter settings.

A filter editor enables users to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators. The resulting filter condition is combined with the field-based filter criteria by the AND Boolean operator.

The filter editor provides a set of logical operators that simplify the process of creating filters for text, numeric and date-time fields.

To apply a filter expression in code, use the WeFilter.Criteria or WebFilter.CriteriaString property.

C#

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

VB.NET

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
  If (Not IsPostBack) AndAlso (Not IsCallback) Then
    '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))
  End If
End Sub

Note

The filter expression is not supported in OLAP mode.