TFS API and schema to get work item info RRS feed

  • Question

  • Hi Team,

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

    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]

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

    Friday, November 24, 2017 4:50 AM

All replies