It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,857
×11,987
×7,449
×1,570
×1,278
×481
×359
×181

question asked: Apr 25, 3:13 p.m.
question was seen: 631 times
last updated: Apr 30, 3:27 a.m.

Related questions

Report Builder - Sort states by specific order

0
Sterling Ferguson-II (1.6k●10●285●273) | asked 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

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

Hi Sterling,


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

One answer

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Pranjan Patel (21●1) | answered Apr 30, 1:06 a.m.
edited Apr 30, 3:27 a.m. by Fariz Saracevic (919●6●13)

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

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.