The default sort order for an attribute's elements is defined at the attribute level and used:
- on a report when no report level sort order is defined.
- when listing elements in a prompt question.
- when an attribute appears in the page-by axis.
Each attribute form can have a default sort order defined independent of the other forms. See the following Strategy Knowledge Base technical notes for more information on how default sort is set and used:
- KB4707 (KB4000-007-0137): How to sort attribute elements displayed in the Property attribute in Strategy Agent 7.0 and above
- KB12174 (KB5700-75x-1581): How to enable a sort order for attributes in the page-by of a report
- KB9033 (KB5700-72X-1023): How to sort on multiple attribute forms in a prompt or when browsing elements in Strategy Desktop 7i - 7.2.x
There may be instances when making changes to the default sort definition does not appear to have an effect, as described in the Strategy Knowledge Base technical note:
KB15029 (KB5700-80X-2283): After changing the attribute form to be sorted on, the changes do not take effect in Strategy Desktop 8.0.x
How does Strategy 9.x resolve the default sort order for an attribute when different sort orders are defined for different forms?
Consider the following cases:
CASE 1
A new attribute is created with three forms, all with sort order set to none.
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
The overall sort order is evaluated and stored in the attribute definition when the attribute is saved. With all form sort orders set to none there is no saved sort order, Strategy defaults to sort ascending by ID.
CASE 2
The same attribute is modified so the forms are now:
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
Now when the attribute is saved, Strategy goes through each form in the order they appear in the main 'Forms' window of the attribute editor. The first form with a defined default sort encountered is set as the primary sort form. Other forms are used to sort elements with the same value for the primary sort form. The attribute default sort order is stored as:
- DESC Descending - Primary sort form
- LongDesc Ascending
CASE 3
The attribute from case 2 is modified so the forms are now:
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
When the attribute is saved, Strategy checks to see if the primary sort form order is set. The primary sort form order has not changed, so Strategy does not reevaluate the default sort order. The order is still stored as:
- DESC Descending - Primary sort form
- LongDesc Ascending
NOTE: Strategy just checks if the primary sort form order has been unset (changed to 'None'). Changing the order from Descending to Ascending or vice versa does not cause the sort order to be reevaluated.
CASE 4
The attribute from case 3 is modified, the forms are now:
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending | This report returns the average and sale for each . So we can see that the employees with the biggest average sales are in 'France' but the strongest regions are in 'USA'.
Tables Intermediate Table Type Permanent table Tables Table Creation Type Explicit Tables Table Qualifier TEMP Tables Create Post String DISTRIBUTE ON (!a) Indexing Intermediate Table Index Don’t create an indexForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCNoneLongDescNoneNoneForm NameForm TypeDefault Sort OrderIDIDNoneDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCDescendingLongDescNoneAscendingForm NameForm TypeDefault Sort OrderIDIDAscendingDESCDESCNoneLongDescNoneAscending |
The primary sort form order has been unset. Upon saving, Strategy will detect the change and reevaluate the default sort order. The attribute sort order is now:
- ID Ascending - Primary sort form
- LongDesc Ascending
