JIRA DB: How to get the epic issuenum of an issue?

[Benjamin chee_guoee]

Hi Community!

I am building a query in the JIRA DB to get the Epic Issuenum for an issuetype in the DB.

I need help getting the Epic issuenum that is related to the particular issue.

SELECT * FROM jiraissue ji
left join customfieldvalue cfv on (ji.id = cfv.ISSUE)and cfv.CUSTOMFIELD = 10332 -- Experty
LEFT join customfieldoption cfo ON cfo.id = cfv.STRINGVALUE
WHERE ji.issuetype = 10300 

 ji.issuetype = 10300 are issues "TaskDEV" in the company. 

Current Query works well to get me issues related to issuetype 10300, but I need to get the Epic that is related to this issue as well, specifically the issuenum of the Epic.

Any help is much appreciated!

Thank you very much!

[Mohamed Benziane]

Hi @Benjamin chee_guoee 

Can you look at this post : https://community.atlassian.com/t5/Answers-Developer-Questions/Where-are-quot-Epic-link-quot-records-stored-in-JiraDB/qaq-p/523554

Like Nic Brough said, avoid using the database and use rather the API.