How to create a named filter to find unblocked issues?

Question

In Jira Cloud, I need to create a named filter to find unblocked issues.

I believe the following ScriptRunner filter does the trick:

issueFunction in linkedIssuesOf("status != done", "blocks")

However, I don't seem to be able to create a named filter for this.  I need a named filter so that I can use it in other extensions that use filters, such as "Links Hierarchy".

If there's a native JQL solution to find all non-blocked issues then that would work.  However, so far I've been surprised to find that this fundamentally important feature isn't supported by JQL, but hopefully I'm wrong.

Brian Braunstein_jgfoj2 · Answer

In a situation like the following:

A---(is blocked by)----->B-----(is blocked by) ------>C-----(is blocked by)---->D

A: status = todo

B: status = todo

C: status = todo

D:  status = done

Then the filter should find C and D, because those aren't blocked.  (I'd then filter D out later too but that's out of scope here).

The filter you provided would find B and C.  issueLinkType = blocks means that it blocks something else, B blocks something else, but it is also blocked so I don't want it returned.

Deivid Araujo · Answer

Well, then maybe

issueLinkType = blocks AND status != Done

Don't have any linked issues to test right now, so I might be not considering all variables.

Brian Braunstein_jgfoj2 · Answer

Thanks for taking a look.  Unfortunately that doesn't work because it will count an issue with all "Done" blockers as still blocked.

You can see the ScriptRunner query in my first post, which seems to do the correct thing (filters out blockers that are already done).  I need a solution that still does that.