How to return all child-issues to a large subset of Epics?

[mattcho2015]

This doesn't seem like it should be that hard, but I can't work it out.  We don't have the JQL Search Extensions plugin.

Seems like I should be able to create a filter that gives me a listing of epics (ID is 71171)...

...and then run a query against all those epics that returns all the child-issues.

issuekey in childIssuesOf("filter = 71171")

This doesn't work, get "Unable to find an issue with matching key filter = 71171"

Any ideas?

Thanks

[Thomas Schlegel · Accepted solution]

Hi @mattcho2015 ,

with plain Jira, this is not possible. Do you have the Scriptrunner app? If so, you can query like this:

issueFunction in issuesInEpics("<your query for selecting all the epics>")

[mattcho2015]

Apologize in advance for my ignorance, but is there a way to tell if we have Scriptrunner?

When I type in your suggested functions, I do indeed get the 'issuesInEpics' command to drop down.  

Here's the query I tried out:

• issueFunction in issuesInEpics("project in (MART, ERSV) AND issuetype = Epic AND fixVersion = "MART PI15"")

but get the error:  Error in the JQL Query: Expecting ')' or ',' but got 'MART'. (line 1, character 96)

When I try it without the "fixVersion" condition it works, but I need that to narrow down the results.  It seems the " character is killing the query?

[Thomas Schlegel]

If you have the issueFunction then you have Scriptrunner ;-)

You have to set the fixversion in single quotes, like this:

issueFunction in issuesInEpics("project in (MART, ERSV) AND issuetype = Epic AND fixVersion = 'MART PI15'")

[mattcho2015]

You ARE the MAN!

[Thomas Schlegel]

Thank you, Matt :-)