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

Prefilter.Criteria Property

Gets or sets the Prefilter‘s expression.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v19.1.dll


public override CriteriaOperator Criteria { get; set; }

Property Value

Type Description

A CriteriaOperator object that represents the Prefilter‘s expression.


Use the Criteria property to obtain the filter expression, which is specified by an end-user in the Prefilter editor. For more information, see the PivotGridControl.Prefilter property description.



The Prefilter is not supported in OLAP mode.


The following code shows how to filter a Pivot Grid Control’s underlying data source using the Prefilter. The filter selects records that contain ‘USA’ or ‘UK’ strings in the Country field.

using DevExpress.Data.Filtering;


pivotgridControl1.Prefilter.CriteriaString = "[" + fieldCountry.PrefilterColumnName + 
                "] = 'UK' OR [" + fieldCountry.PrefilterColumnName + "] = 'USA'";
See Also