How to find a work item's Links in Enterprise Insights
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
All Jira Align work items (Story, Feature, Capability, (Portfolio) Epic...etc.) have a section called “Links” in the Details Panel where you can add external links you want to associate with the work item.
How can you access these link values from Enterprise Insights?
Environment
Jira Align
Solution
These are found in Enterprise Insights's [External Reference] view. The following SQL query shows one example for extracting the Links values via Enterprise Insights:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SELECT TOP (10) [External Reference ID]
,[External Reference Name]
,[External Reference Value]
,[Object Type]
,[Link Type]
,[Date Created]
,[FK Epic ID]
,[FK Capability ID]
,[FK Dependency ID]
,[FK Feature ID]
,[FK Objective ID]
,[FK Risk ID]
,[FK Story ID]
,[FK User Created By ID]
FROM [current_dw].[External Reference]
Was this helpful?