Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Filtering based on linked issue status

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` ?

1 answer

1 accepted

1 vote
Answer accepted

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:

  • Set your card color filter based upon: issueLinkType = "is blocked by"
  • Add an automation rule triggered on issue transition to Done, and delete any links which this issue blocked

If you need to see which issues were blocked/blocking in the past, you can refer to the issue history details.

Best regards,

Bill

Hmm yeah I didn't want to d that because of losing the link but you're right that the history would reveal it, if a little obfuscated... 

 

OK Thanks - I think I'll go with this. Appreciate the help!

Like Bill Sheboy likes this

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.

Best regards,

Bill

The solution I actually ended up with was to apply a label "Blocked" when an issue is linked with "is blocked by" and remove the label when an issue that "blocks" is moved to done/closed 

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Bitbucket Smart Commits vs. Genius Commits - What's the difference?

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...

106 views 0 2
Read article

Community Events

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

Events near you