How to find Jira Align Epic Attributes in Enterprise Insights or Atlassian Analytics for Reporting
Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.
Summary
For reporting purposes, there may be a requirement to extract or display Epic attributes such as Start Date, Target Completion Date, Start/Target Date Modification Time, Epic Status, Epic Status Modification Time, and Epic Status Reports Notes. This information is available across several views in the Enterprise Insights database or tables in Jira Align Enterprise Insights data source at Atlassian Analytics.
Environment
Jira Align
Enterprise Insights
Solution
The below table outlines where to find various Epic Attributes in the current schema:
Tables | Epic Start Date | Epic Target Completion Date | Epic Start/Target Date Modification Time | Epic Status | Epic Status Modification Time | Epic Status Reports Notes |
|---|---|---|---|---|---|---|
[Epic Log] | [Epic Log].[Detail Text] Sample: '...Updated - Start / Initiation (StartDate) Changed - From [...] To [...]' | [Epic Log].[Detail Text] Sample: '...Updated - Target Completion Changed - From [...] To [...]...' | [Epic Log].[Date Audit Event] | N/A | N/A | N/A |
[Epic History] | [Epic History].[Date Target Start] | [Epic History].[Date Target Completion] | [Epic History].[Epic Fact Valid From] | N/A | N/A | N/A |
[Epic Status] | N/A | N/A | N/A | [Epic Status].[Epic Status] | [Epic Status].[Date Saved] | N/A |
[Epic] | [Epic].[Date Start] | [Epic].[Date Target] | [Epic].[Date Last Modified] | N/A | N/A | [Epic].[Epic Status Reports Notes] |
Was this helpful?