nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter Blocked Issue List where Blockers are Resolved

kwicker

I am working on a collaborative project across several, separately-managed teams. A few issues across teams are going to be blockers, so I am trying to find a low key way to surface just a list of all blocked issues. It doesn't have to be anything visual (I know there are solutions for this in place) - just a simple filter that we can keep on a Confluence page.

I have a filter where it is displaying a list of blocked issues in this one project (issueLinkType = "is blocked by"). However, I only want to track issues that are CURRENTLY blocked, not just blocked overall - such as if the "Blocked" issue is marked as DONE, the "Is Blocked By" issue should not show up on my filter because it is technically no longer blocked (the blocker has been removed). If the "Blocked" issue(s) is anything other than DONE, the "Is Blocked By" issue should show up on my filter. I still want to keep historical records of the blockers, so I don't want to have to remove those associations.

Essentially something like - issueLinkType is "is blocked by" and linkedIssues is not "Done"

Any suggestions?

Accepted answers

PD Sheehan

My understanding of the requirement is that you want to show issues where the linked issue is unresolved.

Many of the answers so far are only showing you how to limit the results based on the status or resolution of the issue you want to display in the search, not status on the other side of the link.

I'm not a cloud user, but based on my exploration so far, I don't think that this is possible out of the box.

On Server, that's only possible with 3rd parting JQL function like scriptrunner:

issueFunction in linkedIssuesOf('resolution is empty','blocks' )

With scriptrunner cloud, there is an enhanced search functionality that I've never used but should be relatively similar: https://docs.adaptavist.com/sr4jc/latest/scriptrunner-enhanced-search/enhanced-search-included-functions#id-.EnhancedSearchIncludedFunctionsvCurrent-linkedIssuesOf

All comments

Andrew Kendris_io3cw5

Hello @kwicker I believe the only missing criteria you'll need to add to your JQL is Resolution = "Unresolved". With this addition, you will filter out all the linked issues that are blocked and resolved.

Yuliia_Borivets__SaaSJet_

Hi @kwicker

Agree with the previous comment. Besides, you can add other statuses that can block the issue (as depicted below). For this option, you can try Dynamic Filters: JQL Replacer add-on. It is developed by my team to set queries without JQL.

dynamic.filter.png

Hope you find it helpful.

Regards

kwicker

Thanks, @Andrew Kendris - I tried this addition. This is my JQL to find a list of issues that are blocked by another issue, and are still waiting to be completed:

Project = XYZ AND issueLinkType = "is blocked by" AND Resolution = "Unresolved" AND status != "done"

However, this is still pulling in issues marked as "blocked by" where the blocker is marked as "Done" - it's as if the "resolution" applies to the blocked issue and not the blocker issue. When the blocked ticket is marked as done, then the resolution reads as "Resolved".

We're looking for something like -

Issue is included in the filter when:

Blocker status != Done

Blocked status != Done

Issue is not included in the filter when:

Blocker status = Done

Blocked status !=Done or = Done

Is this possible?

Andrew Kendris_io3cw5

I believe this is possible with some nested conditions. Just doing some trial and error and want to see if this would work:

project in (XYZ) AND (issueLinkType = "is blocked by" OR issueLinkType = "blocks") AND Resolution = Unresolved

kwicker

Thank you, I really appreciate it - I tried that one but it still pulls in blocked issues whose blocked issues are resolved.

PD Sheehan

My understanding of the requirement is that you want to show issues where the linked issue is unresolved.

Many of the answers so far are only showing you how to limit the results based on the status or resolution of the issue you want to display in the search, not status on the other side of the link.

I'm not a cloud user, but based on my exploration so far, I don't think that this is possible out of the box.

On Server, that's only possible with 3rd parting JQL function like scriptrunner:

issueFunction in linkedIssuesOf('resolution is empty','blocks' )

World of Digital Innovation LLC

The core limitation here is that native JQL can filter on the status/resolution of the issue you're displaying, but not on the status of the issue on the other side of the link. So "is blocked by" tells you a blocker link exists, but not whether that blocker is still open.

Two native-ish ways around it:
1. Automation: create a rule triggered on the blocker's status change that sets a label or custom field (e.g. "has-open-blocker") on the blocked issue, then filter on that. Reliable, but you're maintaining state.
2. ScriptRunner's linkedIssuesOf() if you have it — e.g. issueFunction in linkedIssuesOf("resolution is empty", "blocks") — though nested logic gets fragile.

The Resolution = Unresolved trick others mentioned only filters the displayed issue, not the blocker, so it won't fully solve the "blocker is Done" case on its own.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud