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

Is there a way to sort by count for a work item query?

Questions
Tags
Users
Badges
James Paulus
(206●2●21●35) Mar 20 '15, 12:15 p.m.
 In version 4.0.3, I'm not seeing a sortable column of "count".    In my scenario, I have 12 high, 13 medium and 8 low defects.    As a result, the highs show first followed by the mediums and then the lows.   Is there a way to show the medium defects before the high defects?

0 votes

2 answers
6,322 views
0 votes

2 answers

Permanent link
Kevin Ramer
(4.5k●9●186●201) Mar 20 '15, 12:53 p.m.
You could use the Work Item Statistics dashboard viewlet.   This allows you to configure it to an existing work items  query and it can group by some attribute (e.g. Severity)  which will show the count when hovered.   In addition you can drill-through to the underlying items by clicking one of the bars of the graph.

0 votes

Comments
James Paulus
Mar 20 '15, 1:20 p.m.
 That won't work with the way we have our dashboards setup.    We need to keep the widget displays the same.    Here is a visual representation:

Kevin Ramer
Mar 20 '15, 1:34 p.m.
So you already are using that viewlet.  Your example doesn't appear to sort in any fashion.   If by count ( desc ) would expect Med, High, Low.  If by Priority would expect High, Low, Medium.   I just change same viewlet to your format and the sort is from largest count to smallest.  My RTC is 4.0.7 [ I cannot add screen shots with this browser on my RHEL 6.6 o/s ]

Permanent link
James Paulus
(206●2●21●35) Mar 25 '15, 1:32 p.m.
 This enhancement might answer the question: https://jazz.net/jazz02/web/projects/Rational%20Quality%20Manager#action=com.ibm.team.workitem.viewWorkItem&id=117635

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
× 26

Question asked: Mar 20 '15, 12:15 p.m.

Question was seen: 6,322 times

Last updated: Mar 25 '15, 1:32 p.m.

Confirmation Cancel Confirm