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.v24.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

#Declaration

[DefaultValue(false)]
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
ASP.NET MVC Extensions PivotGridSettings
.OptionsOLAP .SortUsingDiscoverXmlMetadata
ASP.NET Web Forms Controls ASPxPivotGrid
.OptionsOLAP .SortUsingDiscoverXmlMetadata

#Remarks

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