是否可以编写TFS查询来获取任务的实际时间? [英] Is It possible to write a TFS Query to get Actual Time Taken for a Tasks?

问题描述

我一直在使用TFS跟踪我的积压项目，现在我正尝试编写查询以查看过去7天中我执行特定任务的时间.到目前为止，我有这个查询:

I have been using TFS to track my backlog items and I am now trying to write a query to see how long I took on particular tasks in the last 7 days. So Far I have this query:

工作项类型=任务

Work Item Type = Task

AND状态=完成

AND截止日期= @Today-7

AND Closed Date = @Today - 7

AND Area Path = @Project

AND Area Path = @Project

AND分配给= @Me

AND Assigned To = @Me

，并添加了关闭日期"列，该列显示了该项目上的工作停止时间.但是我无法获得有关在Task

and have added the column "Closed Date" which shows the time work stopped on this item. But I cannot get any information as to when work started on the Task

感觉数据应该存在于特定任务中，它具有以下类型的信息:

Feels like the data should be there as on particular tasks it has the following kind of information:

这可能吗?我不介意将数据提取到Excel进行分析.

Is this possible? I don't mind extracting the data to Excel to analyse.

我问的原因是因为我想继续比较分配给特定任务的时间量，并将其与实际花费的时间相比较，以帮助我预测将来的时间.

The reason I ask is because I would then like to go on to compare the amount of hours assigned to a particular task and compare it to amount of hours actually taken to help my predictions of time taken in future.

推荐答案

TFS并不是时间跟踪工具.如果您确实愿意，可以使用TFS API查询工作项历史记录，并检查状态转换发生的时间戳.

TFS is not intended to be a time tracking tool. You could query the work item history with the TFS API and check the timestamps on when the state transitions occurred if you really wanted to.

敏捷项目并不关注单个任务需要花费多长时间，而是关注开发团队在设定的时间内提供多少价值.一件事可能估计很低，一项任务可能估计很高，但是只要团队交付他们承诺交付的东西，最终这并不重要.

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.

这篇关于是否可以编写TFS查询来获取任务的实际时间?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！