SQL query help

[nath]

Hi

need SQL query to get all issues associated with the Epic

Thanks,

[petry · Accepted solution]

Hey there,

With the following query, you can see all associations between Epic and Issues, where the "source" column is the Epic ID:

select * from issuelink where linktype = (select id from issuelinktype where linkname = 'Epic-Story Link');

To get the Epic ID, you can run this query:

select * from jiraissue where issuetype = (select id from issuetype where pname = 'Epic');

Hope it helps!

Andre

[nath]

Thanks Andre