corelibraries-devexpress-dot-xtrapivotgrid-1b73c0ee.md
Lists values that specify whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[ResourceFinder(typeof(ResFinder), "PropertyNamesRes")]
public enum PivotOLAPFilterUsingWhereClause
<ResourceFinder(GetType(ResFinder), "PropertyNamesRes")>
Public Enum PivotOLAPFilterUsingWhereClause
| 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.
|
The following properties accept/return PivotOLAPFilterUsingWhereClause values:
Values listed by this enumeration are used to set the PivotGridFieldOptions.OLAPFilterUsingWhereClause property.
See Also