Allow Change Axes Order property

Official Content
This documentation is valid for:

Sometimes it may happen that, so as not to duplicate a Query object by changing the sort order of its elements in a same area to change the view, the developer changes it at runtime. This property allows sorting the fields in the PivotTable according to the order set in the Query object, or the order in which the developer loaded the &Axes collection in the Web Panel in run-time.


False The sort order of the elements is as stated in the Query object. This is the default value.
True If there is code in any Web Panel event that places the elements in a certain order, this will be the order used. If there isn’t any code that rearranges the elements, the order stated in the Query object will be assumed.


In the following example the property is set to True because the sort order in which the developer wants to show the Query object elements is different (reverse) than the order set at design time.

AllowChangeAxesOrder Property Query Example

Sub "SetAttributesOrder"
    &Axis = New()
    &Axis.Name = "ClientActive"  // First
    &Axis = New()
    &Axis.Name = "ClientAdmissionDate"  // Second
    &Axis = New()
    &Axis.Name = "ClientName"  // Third
    &Axis = New()
    &Axis.Name = "ClientId"  // Fourth

AllowChangeAxesOrder Property Example

AllowChangeAxesOrder = False vs AllowChangeAxesOrder = True (the code work)


Output type Table, PivotTable