Prefilter Class
Represents a Pivot Grid Control’s Prefilter.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.XtraPivotGrid.v19.2.dll
Declaration
public class Prefilter :
PrefilterBase,
IFilterFormOwner,
IFilteredComponent,
IFilteredComponentBase,
IUIFilterSource,
IXtraSerializableRelated API Members
The following members return Prefilter objects:
Remarks
A filter editor - Prefilter, enables end-users to build complex filter criteria with an unlimited number of filter conditions, combined by logical operators. The resulting filter condition will be combined with the field-based filter criteria by the AND Boolean operator.
The Prefilter provides a set of logical operators that significantly simplify the process of creating filters for text, numeric and date-time fields.
Note
The Prefilter is not supported in OLAP mode.
Example
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'";