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

Report Builder - Sort states by specific order

Questions
Tags
Users
Badges
Sterling Ferguson-II
(1.6k●14●288●273) Apr 25, 3:13 p.m.

7.0.2


Status:

New
Assigned
Working
Completed

All, of course using Sort does Alphabetical or Reverse. How can I use Report Builder to display the status by the order above, or if I add additional states?

thanks

0 votes

Comments
Fariz Saracevic
FORUM MODERATOR / JAZZ DEVELOPER Apr 25, 5:03 p.m.

Hi Sterling,


You should be able to use custom expression to achieve what you are looking for.

1 answer
829 views
0 votes

One answer

Permanent link
Pranjan Patel
(21●1) edited
Apr 30, 3:27 a.m.

Hi Sterling,


You can get that report by using Custom Expression. So, This method can be implemented by adding the code below to a custom expression.

IF($Work Item:Status$ = "New", 1,

        IF($Work Item:Status$ = "In Progress", 2,

        IF($Work Item:Status$ = "Resolved", 3,

               IF($Work Item:Status$ = "Done", 4,5)

)))


This will add a new column which will allow you to sort based on the number which are related to the status.


Thanks,

Pranjan Patel

1 vote

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
× 1,323
× 481
× 360

Question asked: Apr 25, 3:13 p.m.

Question was seen: 829 times

Last updated: Apr 30, 3:27 a.m.

Confirmation Cancel Confirm