Change issue color if linked ticket is blocking AND not resolved

[Eward Somers]

So I've figured out how to change the card color when the linked issue is a blocker but once that issue has been resolved, the card should no longer be colored like that.

How can I check if a linkissuetype is blocking AND not resolved/done ?

[Petter Gonçalves · Accepted solution]

Hello @Eward Somers

Thank you for reaching out.

I understand you want to create a filter to define a card color to all those issues that:

1 - Has a Linked issue of type is "Blocker"

2 - The Blocker linked issue resolution is Unresolved

Have I understood that correctly?

If that's what you are looking for, I'm afraid you can not filter by the resolution of linked issues, so you will not be able to define a card color with those conditions.

That being said, we have a feature request to implement a JQL parameter for the resolution of linked issues:

JQL function to display all issues linked by the linked issue's resolution 

Feel free to vote and watch the suggestion to increase its priority and also receive notifications about any updates.

For now, a valid workaround would be to use an third-party app that provides a JQL parameter to filter for the resolution of linked issues, like Scriptrunner plugin: 

Scriptrunner - Parameter LinkedIssuesOf 

Let us know if you have any questions.

[Eward Somers]

So I did some digging, and I came up with this:

issueFunction in linkedIssuesOf( "status != Resolved AND status != Done", "blocks")

This seems to mark the ticket in a color when one of the ticket blocking it are not done/resolved.

[Petter Gonçalves]

Hello @Eward Somers

Yes, that would be the query using the Scriptrunner parameter.

Let me know if you need help with anything else. 

[Justin Whitehead]

@Eward Somers/@Petter Gonçalves  when I try to plug that query into the card color JQL I get:

Field 'issueFunction' does not exist or you do not have permission to view it.

Now I have Scriptrunner installed, so I'm not sure why this isn't working if it's working for you.  Was there anything else you did to get this working?