How to retrieve the field Additional Program from Epic detail's tab in Jira Align Enterprise Insights
Summary
The user needs to retrieve the field 'Additional Program' from Epic detail's tab using Enterprise Insights.
Solution
The definition of ‘Additional Programs’ is available in our Help Center as per the article mentioned below
https://help.jiraalign.com/hc/en-us/articles/115000091374-Manage-epics
Additional Programs help to manage epics through multiple programs. You can select Additional Programs among the programs from those portfolios that have the same capability policy as the Primary Program has (the visibility of capabilities for specific portfolios either turned on or turned off under Administration > Settings > Platform). If a program appears in both PIs, it is only available for selection once.
Note: If the Primary or Additional Programs are changed, and one or more program increments assigned are outside those programs, you’ll receive a notification prompting you to change the PI assignments.
The field is actually composed of two columns within the [current_dw].[MAP Epic to Program], the type of the program is given by the [Primary Program Flag] field, when set to ‘Yes’ means that the program is a ‘Primary Program’
EI Schema + EI Queries:
Schema: [current_dw].[MAP Epic to Program]
columns: [FK Program ID and] and [Primary Program Flag]Using [MAP Epic to Program] view:
SELECT [FK Epic ID] as 'Epic ID',
epc.[Epic Name],
ep.[FK Program ID] as 'Program ID',
[Primary Program Flag] 'Is Primary Program',
p.[Program Name] as 'Program Name'
FROM [current_dw].[MAP Epic to Program] ep
left join current_dw.[Epic] epc on epc.[Epic ID] = ep.[FK Epic ID]
left JOIN [current_dw].[Program] p ON ep.[FK Program ID] = p.[Program ID]
where ep.[FK Epic ID] = INSERT EPIC ID -- and[Primary Program Flag] = 'Yes'Simple query:
SELECT ep.*
FROM [current_dw].[MAP Epic to Program] ep
where ep.[FK Epic ID] = INSERT EPIC ID -- and[Primary Program Flag] = 'Yes'Was this helpful?