It's all about the answers!

Ask a question

jazz reporting service sorting by id


Mahari Hill (4861184230) | 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.7k11119) | 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



permanent link
Georg Kellner (840481109) | 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
...

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.