All docs
V20.1
20.1
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

ASPxPivotGrid.Filter Property

Gets the filter settings.

Namespace: DevExpress.Web.ASPxPivotGrid

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

Declaration

[PivotAPIMemberCategory(APICategory.RelationalSource)]
public WebFilter Filter { get; }
<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.

ASPxPivotGrid_Prefilter

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

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

The filter expression is not supported in OLAP mode.

See Also