Where Can I Find the Epic Links to Jira Issues?

Question

Where can I find the Epic links to Jira issues?

Environment

Connector: Jira

Answer

The epic_link column is a custom column and its value is synced to the ISSUE_FIELD_HISTORY table.

To find it, query the epic_link value from the ISSUE_FIELD_HISTORY, looking up the related field_id, which you can find using the FIELD table.

Use the following pseudocode as guidance to query your destination:

SELECT i.id, i.name, ifh.value as epic_link
FROM issue i
JOIN issue_field_history ifh
on i.id = ifh.issue_id
JOIN field f on f.id = ifh.field_id
WHERE f.name = 'Epic link'