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; } } }

JQL to find all Issues connected to a Epic in a specific Status

Per Lindberg_q0xunh

Hi,

im running on prem, and no addons

i would like to be able to fitler out all issues that are connect to my Epics in a specific project that right now is in status implementing

i have tried to use the Issue in ("") function, but then i need to specify the individual issues.

What i would like to do is more like Project = XYZ and Issuetype = Epic and Status = implementing (then show me all issues connected to those issues)

To further complicate things. The Epics are in one project and the related issues are distributed in other projects.

The implementing status is only applicable for the Epics, not for the issues connected to them

Accepted answers

Jack Brickey

how about this...

"Epic link" is not empty and status = implementing

Daniel Turczanski - JQL Search Extensions

Hi @Per Lindberg ,

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

issue in allIssuesInEpic("Project = XYZ and Issuetype = Epic and Status = implementing")

Check out the documentation for more examples.

I hope this helps!
Daniel

All comments

Jack Brickey

how about this...

"Epic link" is not empty and status = implementing

Per Lindberg_q0xunh

that could have worked, but i forgot to say i just want to limit to my projects as well, with that formula i get ALL epics in the entire Jira instance. And also it is the epics that have status implementing, not the issues Otherwise it was good.

Jack Brickey

Then add your projects...

Project in (a,b,c...) and "Epic link" is not empty and status = implementing

Per Lindberg_q0xunh

That does not work since in the projects the issues that are connected to the epics dont have status Implementing, those are only used by the Epics

Daniel Turczanski - JQL Search Extensions

Hi @Per Lindberg ,

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

issue in allIssuesInEpic("Project = XYZ and Issuetype = Epic and Status = implementing")

Check out the documentation for more examples.

I hope this helps!
Daniel

Per Lindberg_q0xunh

Ok, thanks i will look into that then.

thank you very much

Per

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server