This post is the sixth post out of seven that builds the Excel Guide. See the first post here
On this post I will talk about the Parent Child relations between work items and how it works with Excel.
In the Rosario there are new type of links, but the most influencing link type that was added to the Rosario is the Parent/Child link.
Parent/Child link links many child nodes to each parent node, a parent can have many children but each child have only one parent so what we get is an hierarchy of a tree type.
In the Rosario version the Excel has an implementation for that link type.
The way that a Parent/Child is implemented is in columns indentation of the title field, means that the parent will be in the first title field, his child will be on the second and so on up to the bottom of the tree.
Here is the result for a query of type tree that results with one parent user story and one child user story.
To add another level in the tree mark the second line’s title field and clicking the “Add Child” button. (Will be shown in the Rosario version only)
The result is a new work item and a new column of title to show there is one more level in the tree.
You can continue to play with the levels and number of child rows you add to a parent.
Remember that there can be only one parent to each child.
There are other link types in the Rosario, I leave that to the reader to investigate further, other link types will not be shown in the Excel.
In order to add different link types to a work item use the “Links and Attachments” button.
Note that in order to use this button the target work item must be published first.
See you on the last part of this guide on my next post…