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.


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

Hi Kelley!

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

Plugins like Scriptrunner may help you in this case.




Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

865 views 3 9
Read article

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