报告功能进度 [英] Report Feature Progress

问题描述

我们将用户故事与功能相关联。   TFS中是否有办法报告单个功能的进度。 

We have user stories linked to features.  Is there a way within TFS to report progress of an individual Feature. 

用户故事可由多个团队完成，这些团队是根据应用程序创建的。 功能可以跨多个应用程序。 我希望能够报告特定功能的完成百分比。 这可能是完成的故事点
等

User stories can be completed by multiple teams which are created based on applications.  A feature can span multiple applications.  I would like to be able to report a % complete for a particular feature.  This could be story points completed etc

感谢任何信息

谢谢，

詹姆斯

推荐答案

詹姆斯，

在tfs_warehouse数据库中，您可以使用下面的查询在功能下查找用户故事：

Hi James,
In tfs_warehouse database, you could use the query below to find the user stories under a feature:

SELECT [WorkItemSK],[System_State],[System_Title],Microsoft_VSTS_Scheduling_StoryPoints
FROM [Tfs_Warehouse].[dbo].[CurrentWorkItemView]
Where WorkItemSK in (SELECT [TargetWorkitemSK] FROM [Tfs_Warehouse].[dbo].[vFactLinkedCurrentWorkItem] 
                     where [SourceWorkItemSK]=(SELECT [WorkItemSK]  FROM [Tfs_Warehouse].[dbo].[CurrentWorkItemView] 
                                               where system_id={FeatureID}))

然后你可以得到故事情节，每个州的故事点汇总。您可以根据需要计算百分比。

最好的问候

Then you could get stories counts, the summary of story points in each state. You could calculate the percentage whatever your want.
Best Regards

这篇关于报告功能进度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！