PivotGridOptionsOLAP.FilterUsingWhereClause Property
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v24.2.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 |
---|---|
Pivot |
Single |
Available values:
Name | Description |
---|---|
Single |
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 Filter |
---|---|---|
Win |
Pivot |
|
ASP. |
Pivot |
|
ASP. |
ASPx |
|