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?
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:
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 ?
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.
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
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