如何在VS 2017中按日期访问TFS仓库来获取任务ID，功能ID，完成工时？ [英] how to get Task id,Feature id,Complete hrs by accessing TFS Warehouse by date in VS 2017?

问题描述

如何获取任务，功能ID，按日期完成的小时数 SQL SERVER QUERY 。
让我们说有一个
任务123，其中在开始日期为7月1日（1.1.2018）和结束于7月10日（10.7.2018）的Sprint中创建。

 任务123个小时的工作时间为5个小时。完成时间为0，而重命名时间为1-7-2018 5小时。 
并且在7月5日的努力是5个小时完成2个小时，而重命名时间是3个小时。 
并且在7月10日的努力是5个小时，完成是4个小时，剩余时间是1个小时。 
  

所以我如何找到7月1日至7月5日。

• 在数据库中访问哪个表？

解决方案

通常，我们不建议直接查询数据库，可以运行TFS查询或使用

或者您可以尝试此UserVoice 。

how to get Task,Feature id,completed hours by date SQL SERVER QUERY.
lets say there is a task 123 in which was created on a sprint which start date is 1st July(1.1.2018) and end at 10th July(10.7.2018)

task 123 effort hours is 5 hrs. completed hrs is 0 and renaming hours is 5 hrs on 1-7-2018   <br/>
and on 5th July effort is 5 hrs completed 2 hrs and Renaming hours is 3 hrs <br/>
and on 10th July effort is 5 hr and completed is 4 hrs and Remaining hours us 1 hr <br/>

so how can i find task id,Feature id (by Flat Structure) of date from 1st July to 5th July.

• which table to access In the DB ?

解决方案

Usually, we don't recommend query database directly, you could run TFS query or use TFS api to get the information you want:

Or you could try the extension mentioned in this UserVoice.

这篇关于如何在VS 2017中按日期访问TFS仓库来获取任务ID，功能ID，完成工时？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！