Search code examples
tfsworkitemtfs-workitem

TFS 2010 Queries for work item hierarchies with multiple levels


I've build up a hierarchical structure of all my work items with excel - all my work items are now organized in multiple levels.

User Story 1

|-- Task 1

| -- -- Sub Task 1

| -- -- -- Bug 1

| -- -- Sub Task 2

| -- -- -- Bug 2

| -- -- -- Sub Sub Task 3

| -- -- -- -- Bug 4

...

But how can I access all items under a certain work item (e.g., "All under Task 1") and visualize the results in a somehow hierarchical way?

Is this possible with TFS 2010 and VST 2010? Or do I need some third-party tools to get e.g., "All my Bugs for Sub Task 2" or "All Tasks for User Story 1"?

Thank you Konrad


Solution

  • In general you need to construct Work Item Queries in VS that have "Type of Query" equal to "Tree of Work Items".

    To obtain a list of Bugs for Sub Task 2:
    New Query of type "Tree of work items" with Work Item = Sub Task 2 & linked work items Type = Bug

    To obtain a list of Tasks under UStory 1:
    New Query of type "Tree of work items" with Work Item = User Story 1 & linked work items Type = Task

    For an external tool: See here for a nice codeplex-solution that generates DGML - trees of Work Items.