how to get 'epic Link' through SQL Query

[Veera rdy]

Hello,

I'm using the following query to get the custom field values:

select *
from jira_app.CustomFieldValue cfv
join jira_app.CustomField CF on CF.Id = CFV.CustomField
join jira_app.jiraissue issue on issue.id = cfv.issue
join jira_app.project project on issue.PROJECT = project.id
where cf.ID = '101111'

Since epic link is also a custom field, I'm using the same query replacing the id of the CF with the Id of the epic link, it doesn't give any results.

How do I get the epic link for a Story?

Please advice.

Thanks.

[Moga · Accepted solution]

Hi Veera,

This question has been answered in this similar post; Where are "Epic link" records stored in JiraDB?. The data is stored in the issuelink table.

I hope that this helps.

Best Regards, 
Mogavenasan

[Veera rdy]

Thank you.

[Moga]

No worries! Happy to help! :)