nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL query of all cascaded child issues of a parent

Cal_Irvine_b7ce0m

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.

Accepted answers

Mark Segall_iqztfr

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.

All comments

Mark Segall_iqztfr

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.

Nguyễn Hoàng Trung

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

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!

Cal_Irvine_b7ce0m

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_vwcdk7

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud