JQL query of all cascaded child issues of a parent

[Cal.Irvine]

We have an issue hierarchy that uses 5 tiers (3 are in Jira Plans), in order as follows: Initiative, Feature Set, Feature, Epic, base-issues (and sub-tasks, but that is not needed for this query). We have Feature Sets that live in one Software Project, but are parented to an Initiative in another Software Project. 

I need a query that will pull all of the child issues of an Initiative, and then the child issues of the returned Feature Sets, and then their child issues, and so on. I have used "Parent in ()" function for most queries so far.

In essence, I need to pull a list of Feature Sets used a Parent Initiative, and then reference the output of that query (the live list of Issue Keys) in another query to pull all the child Features of those Feature Sets.

[Mark Segall · Accepted solution]

Hi @Cal.Irvine 

You'll want to use this JQL:

issue in portfolioChildIssuesOf(ABC-123)

This will bring in all descendants of the key provided.

[Trung - QA]

Hi Mark Segall, This JQL function is only available to Jira Premium users. Could you provide another JQL ?

[Cal.Irvine]

PERFECT! That is exactly what I needed, and it works great, thank you @Mark Segall. I wasn't aware of functions that are provided through the addition of portfolio, do you know if there is a document where those are listed?

[Suvarna]

if we want all subtasks including their parents through jql .is it possible ?

[Charlotte Santos -Appfire-]

Hi @Cal.Irvine 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all cascaded child issues of the Initiatives:

issue in childrenOfIssuesInQueryRecursive("type=Initiative")

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!