PivotGridOptionsOLAP.FilterUsingWhereClause Property
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v25.1.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
Declaration
[Browsable(false)]
[DefaultValue(PivotOLAPFilterUsingWhereClause.SingleValuesOnly)]
public PivotOLAPFilterUsingWhereClause FilterUsingWhereClause { get; set; }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 |
|
| ASP.NET MVC Extensions | PivotGridSettings |
|
| ASP.NET Web Forms Controls | ASPxPivotGrid |
|