Been trying to implement card colors on my board based on whether there is a linked issue for isBlockedBy with status != Done
Seems like this isn't possible but just wanted to check. [Using vanilla Jira with no ScriptRunner)
Here's what I've tried in the issue navigator:
`project = "TS" AND issueLinkType = "is blocked by" AND linkedIssue in linkedIssues(issueKey) ORDER BY created DESC`
but of course issueKey in linkedIssues(issueKey) is not defined. Is there a way to refer to the issue being searched in this way?
In the card color query I've tried
`linkedIssue in linkedIssues(issueKey, "isBlockedBy")`
Again issueKey isn't a thing. I wasn't sure if in this view there is a keyword to mean "the current issue" but I'm assuming not.
Would be neat if we could do something like:
`issueLinkType = "is blocked by" AND linkedIssue.status != Done` ?
Hi @Phil Barber
JQL is not a SQL, so you will not be able to perform that type of two-level search without a marketplace add-on, such as the example you note of ScriptRunner.
What you could do is solve this with an automation rule, removing the links once a blocking issue completes. For example:
If you need to see which issues were blocked/blocking in the past, you can refer to the issue history details.
Give that a try and see how it helps.
If you later decide you really want to keep the links, this can also be solved using multiple automation rules to scan up/down the links to update a custom field, perhaps HasBlockingLinkedIssue. Solutions like that tend to be brittle as the timing can cause automation loops. Let me know if you want some ideas about that approach.
If you already heard about Smart Commits in Bitbucket, know that you just stumbled upon something even better (and smarter!): Genius Commits by Better DevOps Automation for Jira Data Center (+ Server...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events