PivotGridOptionsOLAP.FilterUsingWhereClause Property

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

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

VB.NET

<Browsable(False)>
<DefaultValue(PivotOLAPFilterUsingWhereClause.SingleValuesOnly)>
Public Property FilterUsingWhereClause As PivotOLAPFilterUsingWhereClause

Property Value

Type	Default
PivotOLAPFilterUsingWhereClause	SingleValuesOnly

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 MVC Extensions	PivotGridSettings	.OptionsOLAP .FilterUsingWhereClause
ASP.NET Web Forms Controls	ASPxPivotGrid	.OptionsOLAP .FilterUsingWhereClause