I have a Service Management project for support. When needed we escalate internally to other teams by creating a ticket on their projects and linking them together.
I want to create a filter where I display my Service Management support tickets in statuscategory=!DONE AND where the linked ticket is also in the same status category. Effectively showing all my support tickets that are still open but skipping those where the linked ticket has statuscategory=Done.
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 this query to find all your issues that have statuscategory=!DONE AND where the linked ticket is also in the same status category.
issue in linkedIssuesOfQuery("status != done") and status != done
Check out the documentation for more examples.
If you have any other questions, please contact our support. We’ll be happy to help you!