Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


How do I list all child issues from parent ticket criteria?

I want to list all initiatives that are child tickets to custom Theme issue type in our org. Can you help with a query for this?

- Themes contain a drop down field for areas

- From these themes, I want a list of all the initiatives

3 answers

1 vote
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.
Apr 13, 2023 • edited

Hi @Bea Tea 

I’m Maurício, a support engineer at Appfire and I’m here to help you.

Unfortunately, using JQL of Jira, 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 initiatives that are children of the Theme issue type:

issue in childrenOfIssuesInQuery("type=Theme”)

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

We’ll be happy to help you!

Best regards,


0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Apr 16, 2023

Hi @Bea Tea 

just to put this out there, another option might be to consider one of the more hierarchy-focused apps from the Marketplace. These apps typically have their own ways of figuring out parent/child relationships between issues, and provide more powerful ways of defining and searching through issue hierarchies. I myself work on such an app, in which your use case would be easy to solve - I'll provide more details below.

The advantage here is that you can actually view your issues in their hierarchy, which depending on your exact use case, may make things considerably easier.

Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Apr 16, 2023

Just to expand on the above, here's how this would look in the app that my team and I are working on, JXL for Jira:


JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies. Once a hierarchy is enabled, you can use JXL's search and filter capabilities to narrow your issues down to exactly what you're looking for.

When you've got your issues, you can work on these issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,



0 votes
Daniel Capizzi
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Apr 12, 2023

Hi @Bea Tea,

Unfortunately this isn't possible with JQL. There is a function called `portfolioChildIssuesOf()` which allows you to fetch the children of an issue, however you need to supply specific issue keys to it. It's not possible to say "get me the children of all themes".

We have an open feature request to support nested queries in JQL which would address this use-case. You can vote on the request and track any updates from our side there.



Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events