Query all cancelled Epics in Jira Align
Summary
Find all cancelled Epics in Jira Align by querying the [current_dw].[Epic history] table. Overcome issues with missing cancelled initiatives in [current_dw].[Epic] table queries.
The [current_dw].[Epic] table does not return cancelled Epics
When querying Epics in Jira Align, cancelled initiatives don't appear in the results when using the [current_dw].[Epic] table. Attempting to query by a known cancelled Epic ID also fails to return results.
Environment
Tested on Jira Align 11.9.1.
Solution
Use the [current_dw].[Epic History] table, which contains historical records including cancelled initiatives. The following query returns cancelled initiatives that no longer exist in the active Epic table:
SELECT TOP (100)
EH.[FK Epic ID],
EH.[Epic Name],
EH.[Epic Description],
EH.[Canceled Flag]
FROM [current_dw].[Epic History] AS EH
LEFT JOIN [current_dw].[Epic] AS E ON EH.[FK Epic ID] = E.[Epic ID]
WHERE EH.[Canceled Flag] = 'Yes' AND E.[Canceled Flag] IS NULL
ORDER BY EH.[FK Epic ID]Updated on June 3, 2025
Was this helpful?
Still need help?
The Atlassian Community is here for you.