Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,256,849
Community Members
 
Community Events
164
Community Groups

JQL Child issues of initiative

Hello, I am trying to use JQL to find all child issues (epics and stories) of an initiative. Many posts point to this article, but I don't think childissuesOf JQL works on my cloud instance for whatever reason. Any tips?

 

https://confluence.atlassian.com/jiraportfolio/portfolio-for-jira-2-10-release-notes-940678731.html#PortfolioforJira2.10releasenotes-childissuesScreen Shot 2021-04-14 at 9.54.39 AM.png

3 answers

1 accepted

3 votes
Answer accepted

Hello @Jade Melcher 

That article is from 2017 and may no longer be applicable.

First, do you have the Roadmaps feature enabled? The article is about the Portfolio product, which was rebranded as Roadmaps and included in JIRA Cloud.

You might want to check out this post which has comments about alternative methods to get the results.

https://community.atlassian.com/t5/Jira-questions/JQL-query-to-find-child-issues-of-Initiative/qaq-p/461409

There is also this article that you might find helpful.

https://confluence.atlassian.com/advancedroadmapscloud/searching-for-issues-using-advanced-roadmaps-details-998651411.html

And there is also this issue in Atlassian's backlog

https://jira.atlassian.com/browse/JSWCLOUD-19543

Yes, we are using roadmaps which is how we are leveraging initiatives :D I will take a look

 

 

Oh wow!! The second link solved it! Instead of childissuesOf it needs to be 

portfolioChildIssuesOf

 

 

THANK YOU so much! 

Like # people like this

How to get child issues of multiple initiatives by using - 

portfolioChildIssuesOf 

@Madhuri Raghute (3P) 

Are you working with Jira Server/Data Center or Jira Cloud.

The second link in my original response no longer leads to the same content, but I found this replacement article:

https://support.atlassian.com/jira-software-cloud/docs/search-for-advanced-roadmaps-custom-fields-in-jql/

Hi. I'm trying to use the following JQL 

issuekey in portfolioChildIssuesOf("PROJ-001")

But it's saying it's unable to find JQL function portfolioChildIssuesOf. I am using Advanced Roadmaps and do not have portfolio (though I understand the product was rebranded), yet the following link explicitly says I can use this function for Advanced Roadmaps. Any ideas?

https://confluence.atlassian.com/advancedroadmapscloud/searching-for-issues-using-advanced-roadmaps-details-998651411.html

Essentially, I am looking for simple JQL that will return a list of Initiatives with no Epics (so I know which ones to focus on at planning). I was hoping something like portfolioChildIssuesOf would help but if anyone has any other ideas of how to accomplish this I would be most grateful. 

If this was a normal parent/child relationship I could use hasLinkType() but, nope, this has to be different! :)

Thanks

I only have the Basic Roadmap under my plan so none of the ChildIssuesOf is available for me to use.  However, I do notice there is a "parent" that I can use to return all of their children stories like this:

parent in (PROJ-001, PROJ-002)

Hope this reply is not too late and resolve your issue.

solved my problem too thanks!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

Upcoming changes to epic fields in company-managed projects

👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...

1,487 views 11 22
Read article

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