Enumerations wont sort with a Querie
When running a Querie in Rational Team Concert (RTC) i wont sort the result based on the values in the Enumerations, if I then in the view press the header (sorting by header) then it sort just fine.... anyone experianced this as well, anyone have a solutions for this?
My enumerations is the numbers from 1 to 20 and an "undefined" and they are sorted in the enumerations setting and when I select it from the drop down.
Accepted answer
Morten, I just tried that on work item query results in RTC 4.0.1 in the Web UI and the Eclipse client. It worked for me.
Please note, I think I remember there was something in previous versions. I think it was in 3.x where I saw something similar.
Please note, I think I remember there was something in previous versions. I think it was in 3.x where I saw something similar.
One other answer
I think it's premature to assume that this is just a bug. I can reproduce this on several environments, including Jazz.net (jazzdev.torolab).
Take for example this query for 4.0.4 stories in the RTC project area. You can't sort by "Story Points" by clicking on the column header - it is plain text and not a click target. However, if you edit the query you *can* set "Story Points" as a sort order column and it sorts... but in any particular order I could detect (Unassigned, Extra Small, Extra Large, XXL, Small, Medium, Large).
On the other hand, you *can* do a column click sort for enumerations like "Priority". If you look at the underlying process XML for priority and severity, you see something like the following:
<-- Priority --><enumeration attributeTypeId="priority" name="priority"><literal default="true" icon="platform:/plugin/com.ibm.team.workitem.common/icons/obj16/priority_unassign.gif" id="1" name="Unassigned"/><literal icon="platform:/plugin/com.ibm.team.workitem.common/icons/obj16/priority_low.gif" id="2" name="Low"/></enumeration>
<!-- Story points --><enumeration attributeTypeId="complexityEnum" name="complexityEnum"><literal default="true" id="0" name="Unassigned" null="true"/><literal id="1" name="Extra Small (1)"/></enumeration>
My point is that the definition of these two enumerations is almost identical in structure (e.g. integer style IDs) but you can column click sort one in the web UI and the other you can't.
I experimented quite a bit with a test RTC server to see if I could do something to make custom enumerations column-click sortable, with no luck. Here are some of the things I tried:
- Store in both process specification and database
- Use Derby as the database and DB2 as the database
- Set external values for each enumeration element
Is there anything I can do to make an enumeration column-click sortable in the web UI?
Comments
