Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

jazz reporting service sorting by id

Questions
Tags
Users
Badges
Mahari Hill
(486●1●184●230) 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....

3 votes

2 answers
3,615 views
3 votes

Accepted answer

Permanent link
Francesco Chiossi
(5.7k●1●11●19) 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

1 vote

Comments
Francesco Chiossi
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
(840●4●81●109) 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
...

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 7,494
× 360

Question asked: Nov 16 '17, 11:20 a.m.

Question was seen: 3,615 times

Last updated: Feb 06 '19, 1:19 p.m.

Confirmation Cancel Confirm