PivotGridOptionsOLAP.SortUsingDiscoverXmlMetadata Property

Gets or sets whether the PivotGrid uses the OrderBy attribute obtained from the OLAP server to sort data.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

[DefaultValue(false)]
public bool SortUsingDiscoverXmlMetadata { get; set; }
<DefaultValue(False)>
Public Property SortUsingDiscoverXmlMetadata As Boolean

Property Value

Type Default Description
Boolean

false

True, to support the OLAP server's OrderBy attribute; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to SortUsingDiscoverXmlMetadata
WinForms Controls PivotGridControl
.OptionsOLAP.SortUsingDiscoverXmlMetadata
ASP.NET Controls and MVC Extensions ASPxPivotGrid
.OptionsOLAP.SortUsingDiscoverXmlMetadata
MVCxPivotGrid
.OptionsOLAP.SortUsingDiscoverXmlMetadata
PivotGridSettings
.OptionsOLAP.SortUsingDiscoverXmlMetadata
Reporting XRPivotGrid
.OptionsOLAP.SortUsingDiscoverXmlMetadata

Remarks

This property is in effect when the SortMode propety is set to Default.

If the SortUsingDiscoverXmlMetadata is set to true, the Pivot Grid sends a special DISCOVER_XML_METADATA request to get an actual attribute value and use this information to sort data.

This is not the default behavior because of backward compatibility. However, you should enable it to support the OLAP server's OrderBy attribute.

See Also