Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

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

Kat Community Leader May 22, 2018

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

2 answers

2 accepted

3 votes
Answer accepted

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 Community Leader Mar 18, 2019

Thanks for adding the Jira Cloud version. :)

Like Abel Lineberger likes this

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.

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

2 - no idea.

0 votes
Answer accepted
Alana Fernando Community Leader May 22, 2018

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 Community Leader May 22, 2018

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

Alana Fernando Community Leader May 22, 2018

Yei!!! Glad to hear @Kat 😊

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 Community Leader Jul 15, 2018

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.

Like Vera Osmantseva likes this

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

Suggest an answer

Log in or Sign up to answer
TAGS

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