Edit on GitHub
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 andISSUE_BOARD
table from Jira to your destination, Fivetran must activate them. Contact our support team for help with activation.