how to get Task id,Feature id,Complete hrs by acce

问题:

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 ?

回答1:

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.