JQL to return 4 levels of Portfolio custom hierarchy Edited

Any guidance here would be greatly appreciated...especially thoughts on my proposed setup of Portfolio.

History

We have upwards of 150 projects in our JIRA instance and are about to install Portfolio.  Rather than adding the Portfolio custom issue type hierarchy to ALL 150 projects I proposed creating only 1 project that houses 2 Portfolio issue types (Portfolio plan source could easily use filters to retrieve the Epics and Stories desired AND the Portfolio issue types).  This was my strategy which I tested and it worked:

  • Product (top level custom Portfolio issue type)
    • RPE (Parent Link is the Product issue type)
      • Epic
        • Story

With the following JQL I can return all the RPEs associated via Parent Link to the Product:

issue = <Product issue #> OR "Parent Link" = <Product issue #>

I wanted to put all the Portfolio issue types into 1 project to save all the admin time it will take to support those issue types in 150+ projects.

This worked fine...until the powers that be decided they wanted 4 Portfolio issue types in the hierarchy above Epic instead of 2; they want this:

  • Product (top level custom Portfolio issue type)
    • General Initiative (Parent Link is Product issue type)
      • Detailed Initiative (Parent Link is General Initiative issue type)
        • RPE (Parent Link is Detailed Initiative issue type)
          • Epic
            • Story

Can anyone help me JQL that would allow me to search and return ALL the items associated with the Product issue at the top level down thru the RPE level?

Or am I way off base with my proposal of going with having the Portfolio issue types in 1 project instead of 150?

Thanks in advance for any help!!!

1 answer

0 vote
Cristiano Oliveira Community Champion Nov 22, 2017

Hi Kelley!

Unfortunately, it seems that it is not possible out-of-the-box.

Plugins like Scriptrunner may help you in this case.

https://community.atlassian.com/t5/Jira-Core-questions/Query-two-levels-hierarchy-in-Jira/qaq-p/216386

Thanks,

Cristiano

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,329 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot