How to retrieve the 'Additional Program' field from an Epic detail's tab using Jira Align 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
When using Enterprise Insights it may be needed to retrieve the Additional Programs info for an Epic. This information is actual stored in multiple tables, which impacts the query that will be used.
Solution
There is no specific field that clearly shows the additional programs, however the information can be retrieved by making use of:
Table: [current_dw].[MAP Epic to Program]
Fields: [FK Program ID] and [Primary Program Flag]
Where the [Primary Program Flag]indicates whether the program is primary or additional:
If set to 'Yes' then the entry is for the Primary Program
If set to 'No' the entry is for an Additional program
An example query that looks for the ID of the Epic, returns the details of the Primary and Additional Programs, along with the full name of the Epic being
1
2
3
4
5
SELECT [FK Epic ID], [Epic Name], ep.[FK Program ID], [Program Name], [Primary Program Flag]
FROM [current_dw].[MAP Epic to Program] ep
LEFT JOIN [current_dw].[Program] ON ep.[FK Program ID] = [current_dw].[Program].[Program ID]
LEFT JOIN [current_dw].[Epic] ON ep.[FK Epic ID] = [current_dw].[Epic].[Epic ID]
where ep.[FK Epic ID] = <EPIC ID>Was this helpful?