Can I get a JQL for getting the list of epic links under a project

[Naveen Navi]

We are having a list of epic links and for each issue, we used to give an epic link. 

Now I want to query the dataset to get the list of epic links and issues

[Craig Nodwell · Accepted solution]

Hi @Naveen Navi welcome to the community.  JQL Jira Query Language will do this easily for you.  Here's a reference page for your review.

[Naveen Navi]

Hi @Craig Nodwell ,

Thanks for your prompt response. The page is really useful for my other queries. But am still not able to frame query for epic links. Could you please help me with a sample query for finding epic link?

[Naveen Navi]

I have managed to retrieve a list of fields, though I'm encountering difficulty obtaining the "Epic Name" value. This value seems to be accessible through the customfield table, but I'm struggling to incorporate it into my current set of data. Now along with this data, am looking for the epic name.

select
it.pname as issuetype,
issuenum,
summary as summary,
assignee as assignee,
reporter as reporter,
priority,
ist.pname as 'issue status',
resolution,
created as created,
updated as updated,
duedate as due_date,
l.label as label,
s.name as Sprint,
c.cname as Component
from jiraissue ji
inner join issuestatus ist
on ist.id = ji.issuestatus
inner join issuetype it
on it.id =ji.issuetype
inner join label l
on l.issue = ji.id
inner join customfieldvalue cfv
on ji.id = cfv.issue
inner join customfield cf
on cf.id = cfv.customfield
inner join AO_60DB71_SPRINT s
on s.id = cfv.stringvalue
INNER JOIN nodeassociation na
ON ji.id = na.source_node_id
INNER JOIN component c
ON na.sink_node_id = c.id