jazz reporting service sorting by id

Mahari Hill (486●1●156●229) | asked Nov 16 '17, 11:20 a.m.

CLM 603

All,

Unless I'm living in the Upside Down world, is there any reason my JRS report, sorted by requirement ID is returning DNG data like so:

1     Requirement
10   Requirement
100 Requirement
2     Requirement
20   Requirement
etc....

Accepted answer

permanent link

Francesco Chiossi (5.7k●1●11●19) | answered Nov 16 '17, 12:03 p.m.
edited Nov 16 '17, 12:04 p.m.

Hello Mahari,

this issue is discussed in the following defects:

Defect 416748 Sorting in JRS is not consistent
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/416748

Defect 386654 RB: Reports sorted on WorkItem ID are not sorted numerically but as string
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/386654

There is a proposed workaround for the DW data source; through custom expressions in 6.0.4 or advanced SQL for earlier releases.

Best Regards
Francesco Chiossi

Mahari Hill selected this answer as the correct answer

Comments

Francesco Chiossi commented Nov 29 '17, 5:59 a.m.

Adding to my previous answer, a technote has been published about this issue with a workaround for both the DW and the LQE data sources:

workitem IDs are sorted alphabetically
http://www-01.ibm.com/support/docview.wss?uid=swg22011064

One other answer

Most liked answers ↑|Newest answers|Oldest answers

0	permanent link Georg Kellner (840●3●77●108) \| answered Nov 16 '17, 11:49 a.m. Seems to be a bug. I can confirm this behaviour in JRS 6.0.3 (Build-ID: JRS_6.0.3-I20170508-2205) ... 1128 199 200 ...

It's all about the answers!

Related questions

jazz reporting service sorting by id

Accepted answer

One other answer

Your answer