It's all about the answers!

Ask a question

RTC query - group by team area

Norman Dignard (356682152) | asked Aug 10 '18, 1:01 p.m.

 We're trying to create a query on work items by filtering by filed against and selective teams. We get the needed data however we need to group the results by team areas.  Our Categories are hierarchical in that some have many subcategories some of which are constrained to specific/different teams.

There is no option in the web or client UI to do a sort/group by team area.  
What options do we have to do this? 

One answer

permanent link
Don Yang (7.6k21105137) | answered Aug 14 '18, 12:31 a.m.
edited Aug 14 '18, 9:08 p.m.

In your query, if you add a column 'Filed Against', and add 'Filed Against' to 'Sort Order', the result will be sorted by Filed Against(associated with Team Area), would that work for you?

Norman Dignard commented Aug 14 '18, 10:00 a.m.

No this won't do the trick. Filed against (aka - categories) are not necessarily restricted to a single team. Two different work items maybe filed against the thing however they are assigned to different teams.  

The sort by filed against would not give a "team area" sorted list.   

Don Yang commented Aug 14 '18, 9:09 p.m.

Your case looks more complex. In my test with JKE Banking project area, "filed against" added to Sort Order does give team area sort result as they are associated.

Your answer

Register or to post your answer.