Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

FieldOLAPFilterUsingWhereClause Enum

Lists values that specify whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v24.2.dll

NuGet Package: DevExpress.Wpf.PivotGrid

#Declaration

public enum FieldOLAPFilterUsingWhereClause

#Members

Name Description
SingleValuesOnly

The WHERE clause is used when the filter condition contains a single field value, either excluded or included into the pivot grid (in OLAP mode). Otherwise, a subselect clause is used.

Always

The WHERE clause is always used when filtering against filter fields in OLAP mode.

Never

The WHERE clause is never used when filtering against filter fields in OLAP mode. A subselect clause is used instead.

Auto

The pivot grid automatically selects when to use the WHERE clause in an MDX query.

#Related API Members

The following properties accept/return FieldOLAPFilterUsingWhereClause values:

#Remarks

Values listed by this enumeration are used to set the PivotGridField.OlapFilterUsingWhereClause property.

See Also