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.