I would like to filter out Epics where Parent issue has a certain label.
Any idea how to do this?
Hi @Miia Toivanen
Just to confirm, you have:
---
If the above is correct, this isn't possible with native JQL, because it does not support sub-queries (i.e Parents with a specific label).
You can either:
Note: These Apps provide additional functions, for example, JQL Search Extensions uses the function ChildrenOfIssuesInQuery
Let us know if you need any additional advice on either option above
Ste
Thank you for the quick answer!
The issue is as you described, and I will check those additional apps.
In case you are planning to introduce some advanced queries, please let me know.
-miia
There is a feature request for this that you can vote for / watch - see: JSWCLOUD-23267
I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.
Unfortunately, using JQL of Jira, you’ll not be able to do it.
In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your epics that are children of initiative(if the parent is not Initiative, only change it in the query) whose label contain X
issue in childrenOfIssuesInQuery(“labels = x and type=Initiative")
Please contact our support if you have any other questions about this query.
We’ll be happy to help you!Best regards,Maurício
welcome to the community!
Just to add to the above: Another direction would be to try one of the more hierarchy-focused apps from the Atlassian Marketplace. These apps have their own, often more powerful ways of establishing and navigating through parent/child relationships. I can only speak for the app that my team is working - JXL for Jira - but in JXL, your use case should be easy to solve. In short,
This is how this looks in action:
Once you've narrowed down your list of issues, you can work on these issue directly in JXL, trigger various operations in Jira, or export your issues for further processing.
As said above, there are several other apps that might help with this. You may already know that you can trial any app for free for 1 month (and depending on the size of your site, it may be free forever) - so if the above looks interesting, perhaps try a few and see which one works best for you.
Hope this helps,
Hannes
It looks like you're new here. Sign in or register to get started.