knowwebapp.com
Reputation: 95
Query work items directy on sql database incase wiql
Because fetch work items from wiql that is very low. I would like to fetch them from database directly but I don't know which table should I get them?
Upvotes: 1
Views: 3631
Answers (1)
M.G.
Reputation: 530
there are 9 views that are intended for creating reports in TFS 2012:
CurrentWorkItemView
WorkItemHistoryView
BuildChangesetView
BuildCoverageView
BuildDetailsView
BuildProjectView
CodeChurnView
RunCoverageView
TestResultView
Please find more info at http://blogs.msdn.com/b/granth/archive/2010/05/09/tfs2010-how-to-query-work-items-using-sql-on-the-relational-warehouse.aspx
Upvotes: 1
Related Questions
- WIQL query to get all item under a workitem
- TFS 2017 How to query Work Items using SQL
- Retrieving work items and their linked work items in a single query using the TFS APIs
- How to query for my recent work items
- TFS 2013 Queries for work item hierarchies with multiple levels
- How to get via a query all work items on which someone has worked?
- Tfs Query to retrieve a particular type of WorkItems that is linked with a given list of other WorkItems
- WIQL: How to get the content of a field of a work item returned by a query
- TFS 2010: Queries based on the elements of other queries?
- How do I write a TFS 2010 Work Item query clause whos value is a field value?