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.