Recursive query or multiple Filed Against equivalent
I am having a problem with querying nested work items that affect my team.
Say I have story 1 assigned to Team A.
Under story 1 I have story 2 assigned to Team B.
Under story 2 I have task 1 assigned to Team B.
Say I want to get all work items that affect the stories assigned to team A. I can do a query that checks the parent Filed against to match team A, but this will not pick up task 1 because it's parent is Filed Against team B. Is there a way to recursively look up the parent tree or have multiple Filed Against selection so that story 2 and task 1 can be associated with team A as well? A third option would be to have a custom field in addition to Filed Against called Team Affected.
Say I have story 1 assigned to Team A.
Under story 1 I have story 2 assigned to Team B.
Under story 2 I have task 1 assigned to Team B.
Say I want to get all work items that affect the stories assigned to team A. I can do a query that checks the parent Filed against to match team A, but this will not pick up task 1 because it's parent is Filed Against team B. Is there a way to recursively look up the parent tree or have multiple Filed Against selection so that story 2 and task 1 can be associated with team A as well? A third option would be to have a custom field in addition to Filed Against called Team Affected.