Skip to main content

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.v23.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design


public bool SortUsingDiscoverXmlMetadata { get; set; }

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


Set SortUsingDiscoverXmlMetadata to true to use the OrderBy attribute that is set to Key or Name to sort data. The Pivot Grid sends a special DISCOVER_XML_METADATA request to get an actual attribute value and use this information to sort data.

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

See Also