Filtering on Linked issues that are closed

Question

Hi All

I want to create a filter to show me all tickets that have a linked issue with a status of closed.

I am basically trying to get the following

project = X AND issuetype = "Employee Offboarding" AND resolution = Unresolved AND linkedIssues in ("Status= Completed")

This however give me an error: Field 'linkedIssues' does not exist or you do not have permission to view it.

Please help

Charlotte Santos -Appfire- · Answer

Hi @Robin Stemmers

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use you can use the following query to show open tickets with closed linked issues:

issue in linkedIssuesOfQuery("status = Completed") AND project=X AND issuetype='Employee Offboarding' AND resolution= Unresolved

Please contact our support if you have any other questions about this query, or the app in general.

We’ll be happy to help you! 😉

Robin Stemmers · Answer

Native Jira

Piyush Annadate _ACE Pune_ · Answer

Hi @Robin Stemmers ,
The Native JQL doesn't offer linkedIssuesOf option. You may need to use additional plugins.  Or manually filter or use automation/custom field to propagate linked issue status.

If using Scriptrunner, that would be as below:

project = X AND issuetype = "Employee Offboarding" AND resolution = Unresolved  and issueFunction in linkedIssuesOf("statusCategory = Done")