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

While performing queries in RTC can we group "status" by work item type ?

Questions
Tags
Users
Badges
Mrudula Deshpande
(11●4) Oct 18 '19, 1:24 a.m.

 When performing queries and looking for particular work item states, would it be possible to group these statuses by the work item type rather than alphabetically? 


0 votes

1 answer
4,514 views
0 votes

One answer

Permanent link
Parameswaran V
(100●18) Oct 20 '19, 2:26 p.m.

 Hi Mrudula,


If your question is specific to 'Work Item Query' then within the 'column Display' Tab - use the 'Sort Order'.
Within that, use 'Type' - and select the sort order.

Regards,
Param

0 votes

Comments
Mrudula Deshpande
Oct 22 '19, 2:07 a.m.
Thank you Parameswaran. But I want to sort 'Status' field in query. So user can easily get all states of one work item together to perform query.

Parameswaran V
Oct 22 '19, 5:55 a.m.
Probably, i am bit unclear - what you meant by ' All state of one work item together'.  Because, one work item can have only one state - at an instance.

Mrudula Deshpande
Oct 24 '19, 3:07 a.m.
While performing query we select state of work item from 'Status' Field(In Condition Field).  In the 'status' field states of all work items are present in alphabetical order. But I want to sort them by work item type. Is this possible?

Mrudula Deshpande
Nov 11 '19, 3:26 a.m.
Can anyone suggest on this? 

Kevin Ramer
Nov 12 '19, 1:26 p.m.
Chances are about 98.7% that the Status is sorted, but by its internal ID.   I would not recommend any attempt to alter those ID as it will create one fantastic nightmarish mess.   If you really want the status names sorted, you'll have to do that external to RTC.  i.e. export the result as a worksheet file and use the facilities of Excel, Open Office or whatever application is at your disposal.

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
× 6,181

Question asked: Oct 18 '19, 1:24 a.m.

Question was seen: 4,514 times

Last updated: Nov 12 '19, 1:26 p.m.

Confirmation Cancel Confirm