0

I'm working in a project with a huge backlog, which structure is defined and can't be changed anymore.

In our Work Breakdown Structure (WBS) we have several epics and their user stories defined. For project reporting purposes we do have "checkpoints" defined.

Each checkpoint has a bunch of epics as predecessors. So only if we have completed all epics, we can pass the checkpoint.
In TFS 2013 I do have a query to display all checkpoints. Checkpoints are a PBI with the title [Checkpoint]. In this query, I get also the predecessors (epics) for this checkpoint.

Now I would like to get all children of these epics (e.g.):

[Checkpoint]"Infrastructure ready"
 -Link Type "Predecessor": [Epic] "Set-up TFS"
  ---Link Type "Child": [Story]"Request project in dev-ops"
  ---Link Type "Child": [Story]"Set-up Build Environment"
 -Link Type "Predecessor": [Epic] "Set-up Development Environment"
  ---Link Type "Child": [Story] "Create Docker-Container"`

Currently, I'm only able to query for the checkpoints and their predecessors. I'm struggling to get the children of the predecessors in the same query.

Adding a picture of the current situation: Query with missing children In the picture, you see that the children of the [Epic] PBI's are missing.

weegee
  • 3,256
  • 2
  • 18
  • 32
Walti
  • 3
  • 2

1 Answers1

1

If you mean that you want to list all the Parent and Child work items, then you can create a type of query : Tree of work items. Reference the first screenshot for detials:

If you want to get the Parent and Child work items for a specific work item, then you can create a type of query: Work items and direct links. Reference the second screenshot for details.

UPDATE:

We can not get all work items with their parent and child work items in one query. You can try to specify the specific work item ID in Work items and direct links query, just as the example in my answer, Then you can get the three level work items related to that specific work item. We can only do this with the query, you may want to get all related work items with the three level, but unfortunately that's not supported.

You have to set-up several queries or have different ID with an OR-Query, that shoule works.

enter image description here

enter image description here

Andy Li-MSFT
  • 28,712
  • 2
  • 33
  • 55
  • Thanks for your answer. However, Tree does not work since I have a mixture of `predecessor` - `Parent` - `Child` query... – Walti Mar 13 '18 at 06:45
  • @Walti What about the `Work items and direct links` query as I mentioned in above answer? Tree type query will list all the work items with the hierarchy. If both of the `tree` and `Work items and direct links` don't work for you, then that means the query can not achieve that. – Andy Li-MSFT Mar 13 '18 at 07:01
  • Thanks for following-up. No unfortunately not. I added a screenshot of the result – Walti Mar 20 '18 at 13:48
  • @Walti We can not get all work items with their parent and child work items in one query. You can try to specify the specific work item ID in `Work items and direct links` query, just as the example in my answer, Then you can get the three level work items related to that specific work item. We can only do this with the query, you may want to get all related work items with the three level, but unfortunately that's not supported. – Andy Li-MSFT Mar 21 '18 at 02:49
  • Thanks for your answer, then I have to set-up several queries or have different ID with an OR-Query. Thanks, I think that will work. – Walti Mar 22 '18 at 06:48