Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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.

example:

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

Hello,

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

https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira?hosting=cloud&tab=overview

Your JQL query would look like this:

issue in allIssuesInEpic("your JQL query")

You can find more info here:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-AllIssuesInEpic(jql-queryorissuekey)

@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. 

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 https://www.j-tricks.com/jqlt-subtask-functions.html. 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 https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html. 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:

https://jira.atlassian.com/browse/JRASERVER-70710

I would appreciate votes / feedback.

Thanks,
Daniel

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.

Hi,

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.

Regards,

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
TAGS
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

36 views 0 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you