It's all about the answers!

Ask a question

Query not sorting as expected


Gary Woodward (20213) | asked Feb 24 '16, 5:56 p.m.

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


Comments
Alexandre Stegani commented 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 commented 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.

One answer



permanent link
Alexandre Stegani (8664) | answered Feb 25 '16, 9:34 a.m.
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

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.