Skip to main content
All docs
V24.1

PivotGridOptionsOLAP.FilterUsingWhereClause Property

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v24.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

[Browsable(false)]
public PivotOLAPFilterUsingWhereClause FilterUsingWhereClause { get; set; }

Property Value

Type
PivotOLAPFilterUsingWhereClause

Available values:

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.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to FilterUsingWhereClause
WinForms Controls PivotGridControl
.OptionsOLAP .FilterUsingWhereClause
ASP.NET Web Forms Controls ASPxPivotGrid
.OptionsOLAP .FilterUsingWhereClause
ASP.NET MVC Extensions PivotGridSettings
.OptionsOLAP .FilterUsingWhereClause
See Also