Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Trying to create a filter to return all child issues of all the Epics in my Jira Project

Trying to create a filter for all child issues of Epics in my Jira Project without using scriptrunner but the advance filter only.


issuekey = EEEP-963 OR issuekey in childIssuesOf(EEEP-963) OR issuekey = EEEP-992 OR issuekey in childIssuesOf(EEEP-992) AND issuetype in ("Portfolio Epic", Capability, Epic, Story) ORDER BY issuetype ASC

this gives me Exactly what I need for my report – the Epic down to the lowest children (sub-task) if it exist in any story.

However, that is limited to manually entering known issuekey. I want to be able to return all Epic, and their respective childIssues. So if I have 100 Epics I should also get children of each epic under them.

Any suggestion or solution to this?

4 answers

1 accepted

2 votes
Answer accepted


You would need a plugin for it. For example, you could use JQL Search Extensions for Jira.

Your JQL query would look like this:

issue in allIssuesInEpic("your JQL query")

You can find more info here:

@Alexey Matveev _Appfire_ thanks for your help, i will request this extension from my IT team. 

You are welcome!

Thanks, the update from my IT team is that they wont want to buy another add on or extenssion. for this purpose. therefore i will still appreciate any solution on how to use the jira filter to return same result. 

Like Jeffrey Bailey likes this

If you don't want to use a plug-in and if Initiative issue type is enabled, you can put all the epics under an initiative and use "issuekey in childIssueOf(InitiativeKey)" to get all epics, tasks, and sub-tasks linked.

Thanks for posting a solution that does not involve the use of a plug-in.

Like # people like this

This only returns the issues for a KNOWN initiative, does it extend to finding all child issues of all initiatives (I can't seem to find a way to nest an initiative search)


I'd like something like

issuekey in childIssueOf(project=MyProj and issuetype=initiative)

but it doesn't seem to exist.  Any clues ?

Like # people like this

That's a good question. You're right, for what I wrote to work you need to manually put known Epics under a known Initiative. I found a couple of solutions (not sure if they are 100% solutions to your question but maybe they might help you find a better solution!). 

1. Found issue in parent(JqlQuery).This function returns subtasks of given JqlQuery. Found it on I think this is also a plug in so I couldn't find this filter in my company's Jira. Give it a try:

project = ABC AND issue in parent("issuetype = Initiative") (change Initiative to Epic if you'd like to)

2. issueFunction in issuesInEpics("project =ABC") - This will return all type of issues of Epics in that project. Found it on Scriptrunner is a plug in.

3. If you don't know the issue keys of the Epics you want the tasks and subtasks of, you could find them by using the following:

project = ABC AND issueFunction in epicsOf("resolution = unresolved")

In this case, they all need to satisfy a condition. In this example that condition is the project and the resolution.

After finding the key of these issues you could use them to get all of the tasks and subtasks.

Like # people like this

solved >

The following gives you all issuetypes linked to any issues picked up by a filter

  1. Create a filter to list all of the initiatives,
  2. save it,
  3. get the filter number from the saved filter's URL, then...


|  issue in linkedIssuesFromFilter(30785)

Like Corinne ROEHRI likes this

This function doesn't exist...! I use JIRA version 8.6.1

@Corinne ROEHRI Did you ever find a solution?  We are looking for the same thing.  Thanks!

I also failed to find a solution not requiring an add-on. As I see this a logical extension of JQL, I filed a feature suggestion:

I would appreciate votes / feedback.


upvoted - it's super frustrating this is not available, seems basic to the tenets of most Agile implementations

UpVoted too.  It's still gathering interest.


you can try our add-on Epic Finder which has many useful functions to find epics and their issues that fulfill different conditions. Please have a look here for more details.

For some examples how to use this add-on, please go to Ultimate Guide.


Lime Trees Support Team

Thanks, the update from my IT team is that they wont want to buy another add on or extenssion. for this purpose. therefore i will still appreciate any solution on how to use the jira filter to return same result

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events