Prefilter.Criteria Property

Gets or sets the Prefilter's expression.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v20.2.dll

Declaration

public override CriteriaOperator Criteria { get; set; }
Public Overrides Property Criteria As CriteriaOperator

Property Value

Type Description
CriteriaOperator

A CriteriaOperator object that represents the Prefilter's expression.

Remarks

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.

xtrapivotgrid_prefilter

NOTE

The Prefilter is not supported in OLAP mode.

Examples

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'";

Implements

DevExpress.PivotGrid.IUIFilterSource.Criteria
See Also