Query not sorting as expected
We have created a custom attribute for the different applications we are developing/enhacing. When adding it in a query and sorting on it it shows the applications in aphabetical order at first but then starts over again. This happens multiple times in the same query.
Does anyone know how to fix this?
We are using a Microsoft (MSSQL) database.
Thanks for your reply in advance,
Gary
One answer
Hi Gary,
According to the work item below, the sorting of enumeration attributes in a query is based on the enumeration's IDs, rather than the name. Can you confirm if you´re experiencing this behavior?
https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=175676
According to the work item below, the sorting of enumeration attributes in a query is based on the enumeration's IDs, rather than the name. Can you confirm if you´re experiencing this behavior?
https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=175676
Comments
Alexandre Stegani
Feb 24 '16, 6:06 p.m.Hi Gary,
What is the type of the custom attribute (small string, enumeration, etc)? What version of RTC are you using?
Gary Woodward
Feb 24 '16, 6:38 p.m.Thank you for your response, Alexandre. RTC version is 5.0.2 and the Application custom attribute is an enumeration. Currently, we have all applications listed in one enumeration.