It's all about the answers!

Ask a question

Query not sorting as expected

Gary Woodward (20212) | 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,


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?

Your answer

Register or to post your answer.