获取工作项信息的TFS API和模式 [英] TFS API and schema to get work item info

问题描述

Hi Team，

我打算从TFS数据库查询数据中编写一些实用程序。

I am planning write some utility to Query data from TFS Database.

我确实找到了一些信息互联网
https://stackoverflow.com/questions/27919508/tfs -api-get-work-item-data 。

SELECT id，Microsoft.VSTS.Scheduling.CompletedWork，Microsoft.VSTS.Scheduling.RemainingWork，Microsoft.VSTS.Scheduling.OriginalEstimate

    FROM WorkItems

    WHERE [System.TeamProject] = @project 

       与  [System.WorkItemType] IN GROUP'Task Category' 


    ORDER BY [System.Id]

I did find some info on the internet at https://stackoverflow.com/questions/27919508/tfs-api-get-work-item-data.
SELECT id, Microsoft.VSTS.Scheduling.CompletedWork, Microsoft.VSTS.Scheduling.RemainingWork, Microsoft.VSTS.Scheduling.OriginalEstimate
    FROM WorkItems
    WHERE [System.TeamProject] = @project 
        AND  [System.WorkItemType] IN GROUP 'Task Category' 
    ORDER BY [System.Id]

是否有任何有用的链接来获取架构信息（如WorkItems表的名称列表示例Prority，Severity，IterationPath等）？

Is there any usefull link to get schema information( Like columns names of WorkItems Table example Prority, Severity, IterationPath e.t.c) ?

推荐答案

您需要什么样的数据？

what kind of data do you need?

您不应该直接连接到数据库，而是使用API​​：
https://www.visualstudio.com/en-us/docs/integrate/api/overview

You shouldn't connect directly to the Database, but use the API: https://www.visualstudio.com/en-us/docs/integrate/api/overview

这篇关于获取工作项信息的TFS API和模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！