Represents a Pivot Grid Control’s Prefilter.
public class Prefilter : PrefilterBase, IFilterFormOwner, IFilteredComponent, IFilteredComponentBase, IUIFilterSource, IXtraSerializable
Public Class Prefilter Inherits PrefilterBase Implements IFilterFormOwner, IFilteredComponent, IFilteredComponentBase, IUIFilterSource, IXtraSerializable
Related API Members
The following members accept/return Prefilter objects:
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.
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'";