It's all about the answers!

Ask a question

RTC query - group by team area


Norman Dignard (356696177) | 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.7k21114139) | 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?


Comments
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.


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.