RTC query - group by team area
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.
One answer
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
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.
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.