Skip to content

Latest commit

 

History

History
32 lines (23 loc) · 1.48 KB

work-item-category-tables.md

File metadata and controls

32 lines (23 loc) · 1.48 KB
title titleSuffix description ms.technology ms.topic ms.assetid ms.author author ms.date
Work Item Category tables
Azure DevOps Server
Learn how to query for categories of work items defined in Azure DevOps Server.
devops-analytics
reference
ae8ea834-400f-4cda-98d4-a7e612c91cce
kaelli
KathrynEE
10/20/2021

Work Item Category tables

[!INCLUDE temp]

You can query for categories of work items by using the FactWorkItemToCategory and DimWorkItemCategory tables. You can organize the results of other work item queries by category if you join these tables with the DimWorkItem by using FactWorkItemToCategory.WorkItemTypeName = DimWorkItem.System_WorkItemType.

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 Tables for Work Item Category

FactWorkItemToCategory is associated with the following dimension tables:

  • DimWorkItem

  • DimWorkItemCategory

For more information, see these articles: