nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Naveen Navi_es0uc4

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

Accepted answers

Craig Nodwell_7eve9b

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.

All comments

Craig Nodwell_7eve9b

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_es0uc4

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_es0uc4

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud