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

[Per Lindberg]

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

[Jack Brickey · Accepted solution]

how about this...

"Epic link" is not empty and status = implementing 

[Per Lindberg]

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]

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

[Jack Brickey]

You can’t achieve that without an addon. 

[Daniel Turczanski - JQL Search Extensions · Accepted solution]

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

[Per Lindberg]

Ok, thanks i will look into that then.

thank you very much

Per