It's all about the answers!

Ask a question

jazz reporting service sorting by id

Mahari Hill (4861156229) | asked Nov 16 '17, 11:20 a.m.

CLM 603


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

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

Defect 386654 RB: Reports sorted on WorkItem ID are not sorted numerically but as string

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

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

One other answer

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


Your answer

Register or to post your answer.