Filtering on Linked issues that are closed

[Robin Stemmers]

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

[Piyush Annadate _ACE Pune_]

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")

[Charlotte Santos -Appfire-]

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! 😉

[Calvin]

Are you using ScriptRunner or just native Jira? I think with script runner they have

issueFunction in linkedIssuesOf("status = Completed")

[Robin Stemmers]

Native Jira