JQL experts - how can I get a list of issues under an initiative?

[Kat]

*Scenario:* I have an initiative with 5 epics and a bunch of issues under each epic.

Is there any way I can use JQL to get a list of issues where the epic link of the issues is linked to a specific initiative?

Right now I am typing out the keys for all of the epics but it is always nice when there is a faster way. 

[Abel Lineberger · Accepted solution]

And for those of us on cloud, where the above childIssuesOf function does not work...

issuekey in portfolioChildIssuesOf("<issuekey>")

 That will return all issues that parent back to the initiative issue key listed.  YEAH!

[Kat]

Thanks for adding the Jira Cloud version. :)

[gianfranco franceschi]

thanks a lot but I have got a couple more questions: 

1- I cannot find the reverse function, ie. something called "portfolioParentIssuesOf(""), does it exist? How can we obtain the same effect if it does not?

2- does the portfolioChildIssueOf accept a subquery as argument? 

would greatly appreciate any answer.

[Abel Lineberger]

1 - A given issue can only have a singular parent - thus no function to search. 

2 - no idea.

[Alana Fernando · Accepted solution]

hi @Kat,

This is possible since portfolio 2.10.

issuekey in childIssuesOf("<Issue key>")

Reference:

Portfolio for Jira 2.10 release notes

Hope this helps! 

[Kat]

Legend! You have saved me so much time @Alana Fernando

[Alana Fernando]

Yei!!! Glad to hear @Kat 😊

[Anilkumar B]

Hi ,

issuekey in childIssuesOf("<Issue key1>" , "<Issue key2>")

Gives me an error   "Function 'childIssuesOf' expected '1' arguments but received '2'." because the function wont take more than one argument. So how can i solve this.

[Kat]

You can only have one issue key (the key of the initiative) in this JQL. You could use OR and repeat the JQL for each initiative (I have not tested this myself).

The list of child issues does include the epics as well as the stories and tasks under the epics.

[Sidharth Kapoor]

Thank you Alana - saved me so much time and effort!