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
Next: Root
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
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
I know how to a filter for a specific Parent or Parent Link but I need a filter that gives me a list of tickets that are "parents".
Hi @Kathrin
As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.
With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.
Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions
You can use our function ParentsOfIssuesInQuery for a given JQL subquery it finds parents of resulting issues. For example, you can use the query below to find all my tickets’ parents.
issue in parentsOfIssuesInQuery("assignee=currentUser()")
Check out the documentation for more examples.
If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício
You can only achieve this using some third-party Add-on like JQL Search Extensions for Jira & reports or JQL Booster Pack
With the first two, you'll get a function called parentOf()
In Scriptrunner there is a built-in function for this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Kathrin
I do not agree with the other answers.
Simply use the following, where "X" is your project:
project = X AND issuetype not in subTaskIssueTypes() AND "Parent Link" is not EMPTY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry I misled you with one of my custom fields that allows this filter. Unfortunately I have to agree with the others. I worked around it by using automation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.