How to retrieve Epic Intake form data in Jira Align Enterprise Insights
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Summary
This article shows how to retrieve Epic Intake form data using Enterprise Insights.
Environment
Jira Align
Solution
Epic Intake information is stored in the Enterprise Insights '[Epic Intake]' table:
[current_dw].[Epic Intake]
[export_dw].[Epic Intake]
For example, to retrieve the following Epic Intake information which uses a custom intake form called 'FxIntake'
(as viewed from the Epic details panel)
You can use a SQL query such as the one below:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SELECT ei.[Epic Intake ID],
ei.[Epic Intake Form],
ei.[Epic Intake Item],
ei.[Epic Intake Value],
ei.[FK Epic ID],
ep.[Epic Name],
ep.[Epic State],
ei.[FK User Owner ID]
FROM current_dw.[Epic Intake] AS ei
LEFT JOIN current_dw.Epic AS ep ON ep.[Epic ID] = ei.[FK Epic ID]
where [FK Epic ID] = 7841 -- for a specific epic
-- and ei.[Epic Intake Form]='FxIntake' -- for a specific intake form
-- and ei.[FK Epic ID] !=0 -- to remove the permanently deleted epicsOnce the query is executed, here is an example of the result it shows:
đź’ˇ The values in the [Epic Intake] table will be populated only once the intake item/question has been populated with a value at the Epic level.
Was this helpful?