RTC query - group by team area

Norman Dignard (356●6●82●152) | 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

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Don Yang (7.6k●21●105●137) | 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.

It's all about the answers!

Related questions

RTC query - group by team area

One answer

Your answer