Where Can I Find the Epic Links to Jira Issues?link

Questionlink

Where can I find the Epic links to Jira issues?

Environmentlink

Connector: Jira

Answerlink

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'
content_copy

NOTE: To sync the epic_link column and ISSUE_BOARD table from Jira to your destination, Fivetran must activate them. Contact our support team for help with activation.