Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

TFS 2013: Get all work items below a certain parent

how can I define a query in TFS 2013 (Team Explorer 2013) to get all items as a list below a certain toplevel workitem:

|--+-Parent 1    |    |--+-Child 1    |  |--Child of Child 1    |    |--+-Child 2    |  |    |  |--Child of Child 2    |    | ...  

Result:

  • Child 1
  • Child of Child 1
  • Child 2
  • Child of Child 2

Is this possible?

Thanks, Konrad

like image 464
Konrad Avatar asked May 21 '14 11:05

Konrad


People also ask

What is WIQL query?

A WIQL query consists of a SELECT statement (similar to that of the SQL language) that lists the fields to be returned as columns in the result set. (Learn more.) In TestArchitect, you might use a WIQL query to specify the location(s), in terms of test points, to which TA results are to be uploaded to TFS.

Which work item is used to track the specific function of applications or sets of work in an agile process?

Product Backlog Items and Tasks are used to track work, Bugs track code defects, and Epics and Features are used to group work under larger scenarios.

What is query in TFS?

The TFS query is used when looking for changes in TFS, such as new or modified work items. If the query returns work items of types that are not mapped in the synchronization mappings, the unmapped work item types will be ignored and will not be synchronized.


1 Answers

Step 1 - Select "Tree of work items"

Step 2 - Set up the query as usual for the top level work items, for example only "Epic" work items with id 4247 (whatever you like really).

Step 3 - Under "Filters for linked work items" you can exclude descendent items, for example you could show only PBIs, or only bugs etc.

Example Query

like image 154
Fenton Avatar answered Sep 30 '22 19:09

Fenton