Find all issues with a blocked linked issue that is now closed

[James Milenkovic]

We have an automation that flags tickets when they are blocked by another ticket, and unflags when that blocker is closed. 

Sometimes, that automation doesn't work. 

I want to write a query where I can search for any issue that has a blocker linkedissue on it that has been resolved. 

I only want to use JQL. 

I believe I did it a while ago by doing a nested filter, but I can't for the life of me find the solution. 

[Harsh]

Hi @James Milenkovic 

Can you please try - issueFunction in linkedIssuesOf('project = xyz and status = done', 'is blocked by')

As per my understanding this should work.

Thank you

[James Milenkovic]

I don't have "issueFunction" 

"

Field 'issueFunction' does not exist or you do not have permission to view it."

And I am the admin

[Harsh]

@James Milenkovic 

My bad i was referring to JIRA DC/server. Can you try using 'haslinks' ?
This is what I remember, but not sure.

Hope this helps

[James Milenkovic]

I think that's only if you have Scriptrunner, which I do not