| title | titleSuffix | ms.technology | ms.topic | description | ms.assetid | ms.author | author | ms.date |
|---|---|---|---|---|---|---|---|---|
Current Work Item tables |
Azure DevOps Server |
devops-analytics |
reference |
Query for data about the current state of bugs, task, and other type of work items |
8f70c31b-1c6f-4d5b-8413-3948a298d879 |
kaelli |
KathrynEE |
10/17/2017 |
[!INCLUDE temp]
You can query for data about the current state of bugs, tasks, and other types of work items by using the FactCurrentWorkItem table and the associated dimension tables.
For information about the measures and dimensions that are associated with these tables in the SQL Server Analysis Services cube, see Test cases and work items.
FactCurrentWorkItem is associated with the following dimension tables:
-
DimArea
-
DimIteration
-
DimPerson
-
DimTeamProject
-
DimWorkItem