Welcome to the Jazz Community Forum
Enumeration is not sorted in query

I have created an enumeration (Escalationlevel) with 4 entries, they represent Levels, therefore they look like this:
L0 - xxxxx
L1 - xxxxx
L2 - xxxxx
L3 - xxxxx
the attribute is part of a query, and want to sort the colum Escalationlevel. The Attribute was added to the sort order, but it is not sorted:
any idea how to configure the query or the enumeration so that the levels will be sorted accordingly?
L0 - xxxxx
L1 - xxxxx
L2 - xxxxx
L3 - xxxxx
the attribute is part of a query, and want to sort the colum Escalationlevel. The Attribute was added to the sort order, but it is not sorted:
any idea how to configure the query or the enumeration so that the levels will be sorted accordingly?
2 answers

The query result is sorted by enumeration id instead of enumeration value. There is an enhancement request to address the issue https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=175676

Sometimes, the order shown is according to the order in the source file (RTC config).
I usually either recreate the entries in the correct order (from the GUI), or go to the source and move things around.
You can check if it corrects your problem...
I see in your comment that your ids are out of order...
I usually either recreate the entries in the correct order (from the GUI), or go to the source and move things around.
You can check if it corrects your problem...
I see in your comment that your ids are out of order...