You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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
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!
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.
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,
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. https://jira.atlassian.com/browse/JRACLOUD-21936