Question

Where can I find the Epic links to Jira issues?

Environment

Connector: Jira

Answer

The epic_link field is a custom field and its value is synced to the issue_field_history table. To find it, query the epic_link value from 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'

Note: For the epic_link field and issue_board table to be synced into your destination, these need to be explicitly activated by our team. Please create a Support Ticket for help with activation.