PivotGridOptionsOLAP.PrefilterUsingWhereClause Property
Gets or sets whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v20.2.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.WindowsDesktop.PivotGrid.Core
Declaration
[Browsable(false)]
[DefaultValue(PivotOLAPFilterUsingWhereClause.SingleValuesOnly)]
public PivotOLAPFilterUsingWhereClause PrefilterUsingWhereClause { get; set; }Property Value
| Type | Default | Description |
|---|---|---|
| PivotOLAPFilterUsingWhereClause | **SingleValuesOnly** | A PivotOLAPFilterUsingWhereClause enumeration. |
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 PrefilterUsingWhereClause |
|---|---|---|
| WinForms Controls | PivotGridControl |
|
| Reporting | XRPivotGrid |
|
| ASP.NET MVC Extensions | MVCxPivotGrid |
|
| PivotGridSettings |
|
|
| ASP.NET Web Forms Controls | ASPxPivotGrid |
|