CODEWITHSUNDEEP
tfs
Bill Greer
Bill Greer

Reputation: 3156

How do I find all of the child tasks of User Stories and Bugs?

I am trying to create a report showing estimated time vs actual time using Team Foundation Server 2017 for User Stories and Bugs. If I execute the following query I get all of the tasks and bugs:

SELECT *  FROM [Tfs_Warehouse].[dbo].[DimWorkItem]

I understand that a User Story can have zero to many tasks and the same goes for a Bug. How do I find the parent User Stories and child tasks as well as the Bugs and their child tasks?

The end goal is a report something like the image below:

enter image description here

Upvotes: 2

Views: 3911

Answers (2)

Shamrai Aleksander
Shamrai Aleksander

Reputation: 16018

You also may use RDL report "Stories Progress" and customize it.

  1. Edit parameter "DeliverableCategory" to include bugs in your report.

Edit Parameter

Report: Report 2. Edit parameter "IncludeTasks" to show childs.

Edit Parameter

Report: Report

  1. Also you may find sql queries to see tables and views that you may use in your custom report:

SQL Query

Upvotes: 0

PatrickLu-MSFT
PatrickLu-MSFT

Reputation: 51103

It's not hard to find all of the child tasks of User Stories and Bugs.

You can use work item query and linking filters to select Child and Related link types, such as below:

enter image description here

However, there is no build-in feature to sum child task hours to parent in TFS. And TFS is also not intended to be a time tracking tool. To achieve this, you could either use some sever side plug-in such as tfsaggregator or some 3-rd party extension such as Imaginet Time Sheet & Timetracker. More details please refer this similar question: TFS - how do I sum child task hours to parent

Agile projects don't focus on how long individual tasks take -- they focus on how much value the development team is providing over the course of a set period of time. One thing might be estimated low, one task might be estimated high, but it ultimately doesn't matter as long as the team delivers what they committed to deliver.

Also take a look at this question: Is It possible to write a TFS Query to get Actual Time Taken for a Tasks?

Upvotes: 2

Related Questions