Can I write a query which will find blockers ?

[Robert Dibley]

I'd like to find all issues which are blocking other issues and are not yet completed, however I cannot see any way to do this with the query language. Ideally what I would want would be something like this :

resolution IS EMPTY AND linkedIssues(issue, "blocks") IS NOT EMPTY

Is there some alternative method I can use to get this information ?

I'd be perfectly happy if it was a dashboard gadget rather than a query, but I can't see any gadgets which can do this either.

[JamieA · Accepted solution]

You can't do it in ondemand. For hosted there are various plugins available, eg https://studio.plugins.atlassian.com/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-linkedIssuesOf%28Subquery%2Clinkname%29

[C_ Faysal]

can you try this jql please?

resolution is EMPTY AND issueFunction in hasLinks("blocks")

[JamieA]

That's not available in AOD :-(

[C_ Faysal]

sorry. didn't knew that. too bad though :(