Prefilter Class

Represents a Pivot Grid Control's Prefilter.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v20.1.dll

Declaration

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:

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.

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

Inheritance

Object
DevExpress.Utils.Controls.DisposableObject
See Also