JQL query to find issues that are blocked by another (not done) issue

[Nici Kalmes]

Ultimately, I would like to find a way to change the card color of an issue when it is blocked by another issue and that blocking issue is not done. 

I'm looking for a query to return back this information. 

I have this query, but this does not limit to only issues still blocked. I need access to the blocking issue's status. 

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

If there's another way this should be done with automation, I am open to that as well. 

[Trudy Claspill · Accepted solution]

Hello @Nici Kalmes 

Jira does not provide the ability to access the status of linked issues natively as part of its JQL features. You would need to use a third party app that extends the JQL searching fields to get that.

You might be able to solve this with automation by creating a custom field in the blocked issue that you update based on status changes in the linked "is blocked by" issues. The rule would be triggered by updates to the status of issues (the ones that show the "blocks" side of the relationship). You would look for issues linked to that one by the specified link. You could then update the field in the blocked issue to keep track of there being unresolved issues blocking it.

[mauricio.groth]

Hi @Nici Kalmes 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all the issues that are blocked by another (not done) issue

issue in linkedIssuesOfQuery("status != done") and linkType = 'is blocked by' 

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício