JQL query of all cascaded child issues of a parent

Cal_Irvine February 20, 2024

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.

2 answers

1 accepted

1 vote
Answer accepted
Mark Segall
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 20, 2024

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 February 20, 2024

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

Cal_Irvine February 21, 2024

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?

Like Mark Segall likes this
0 votes
Charlotte Santos -Appfire-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 21, 2024

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!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events