Work Item PR Report

Purpose

Work Item PR Report is a lightweight Azure DevOps extension that helps teams gain visibility into how work items are implemented across repositories. It scans the hierarchy of a given work item (such as a Feature or Epic), gathers all linked pull requests (PRs) from that hierarchy, and generates a consolidated report of affected repositories.

This is especially useful when:

• You want to understand the development impact of a large feature
• You need to validate PR coverage before closing a parent work item
• You’re conducting technical audits or preparing for release reviews

The report helps developers, tech leads, and managers save time by eliminating the need to manually inspect each child work item or navigate through scattered PR links.

How to Use

1. Navigate to Boards → Work Item PR Report from your Azure DevOps project menu.
2. Enter a work item ID (e.g., Feature, Epic, or User Story).
3. Click "Generate Report."
4. The tool will:
   • Recursively traverse the hierarchy of child work items
   • Collect all pull requests linked to any level of the hierarchy
   • Display a detailed table with repository name, PR ID, status, and more
5. Optionally, enable the "Latest PR" checkbox to show only the most recent PR per repository.

Output Table

Once the report is generated, results are shown in a structured table that highlights all relevant pull requests across repositories. The table provides details such as repository name, PR ID, name and statis, related work item ID and title.

Filtering Options

To make the report more actionable, you can apply dynamic filters to refine results:

• PR status filter – show only active, completed, or abandoned PRs
• 'Latest PR only' filter – display only the most recent PR per repository

These filters help you quickly locate the most relevant information without wading through the entire hierarchy.

CSV Export

For audits, reporting, or offline analysis, you can export the full table into a CSV file with one click. The CSV includes all key columns and applies any active filters, ensuring you capture the exact dataset you need.

The exported file can be opened in Excel, Google Sheets, or imported into other tools for further processing.

Performance & Security Note

The execution time depends on the number and depth of child work items under the selected work item. For large epics with many stories and tasks, scanning may take several seconds.

All operations are performed entirely on the client side. No data is transmitted externally, making this tool safe for secure and sensitive environments.

Feedback

I’d love to hear your thoughts! Feel free to share suggestions, feature requests, or bug reports to help improve the tool for everyone.