Find issues that are not currently blocked

[Don Vaughn]

one can use issueLinkType() to find issues that block other issues, but I'm not clear how to filter OUT cases when the blocking issue was been Closed (and thus isn't really blocking anymore).

[Muhammad Ramzan(Atlassian Certified Master)]

@don you can use  JQL Search Extensions for Jira & reports , it will fulfill your needs.

Following query is for cloud version 

Find all issues which are blocked by another issue

linkType = "is blocked by"

Reference

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3375124/JQL+Reference+Cloud#JQLReference(Cloud)-LinkedIssueType

[Jack Nolddor _Sweet Bananas_]

Hello Don,

Sadly, issueLinkType() function only allows you to specify the link description but not the status of the destination issues, so you can not remove from your filter those issue that are currently blocked by Done issues.

You must go for a third-party app, ie. using JQL Booster Pack (FREE) you can type the following:

- Retrieve all issues blocked by unresolved issues

issue IN linkedIssuesOf("resolution IS EMPTY", "blocks")

Hope this helps,

Regards

[Don Vaughn]

Thanks Jack-

That was exactly what I was looking for. Unfortunately we use Jira Cloud (not server) which JQL i guess doesn't support. Did you have any other recommendation that was similar?

[Jack Nolddor _Sweet Bananas_]

Sure!

You can get the same behaviour via ScriptRunner Enhanced Search by Script Runner for Jira Cloud