Skip to content

Latest commit

 

History

History
38 lines (26 loc) · 1.35 KB

table-reference-current-work-items.md

File metadata and controls

38 lines (26 loc) · 1.35 KB
title titleSuffix description ms.technology ms.topic ms.assetid ms.author author ms.date
Current Work Item tables
Azure DevOps Server
Learn how to query for data about the current state of bugs, task, and other type of work items.
devops-analytics
reference
8f70c31b-1c6f-4d5b-8413-3948a298d879
kaelli
KathrynEE
10/19/2021

Current Work Item tables

[!INCLUDE version-lt-eq-2020]

Use the FactCurrentWorkItem table and the associated dimension tables to query for data. Find out about the current state of bugs, tasks, and other types of work items.

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.

Fact Table for Current Work Items

FactCurrentWorkItem is associated with the following dimension tables:

  • DimArea

  • DimIteration

  • DimPerson

  • DimTeamProject

  • DimWorkItem

For more information, see these articles: