Automation to add flag when issue is blocked by a ticket not in Done status

Question

Hello,

Can someone help me with creating an automation rule for the following please:

I want to add a Flag (Impediment) to any issues in a future sprint that is 'Blocked By' an issues with an Open status. I.e. clearly alert users that a ticket needs to be unblocked for an up-coming sprint

I believe the above is doable by using the "When: Issue linked" and Type 'Blocks' but the tricky part is I want to run it on all existing issues in a Project and not just for subsequent issues where the Blocked by link is created.

Any ideas? As I am using the "When: Issue linked" trigger, I cannot replace that with a Schedule trigger

Bill Sheboy · Answer

Hi @Darren Mason and @John Funk

Another approach for your scheduled trigger rule to flag the earlier issues is...

* trigger: scheduled with JQL to find any issues left to update (i.e., meet your criteria and are not yet flagged)
* action: lookup issues on more JQL to find any of the predecessors creating blocks
* advanced compare condition: check if the lookup has any issues
* action: flag the current (trigger) issue (as the scheduled trigger allows you to iterate over them)

Kind regards,
Bill

John Funk · Answer

Yeah, you would need ScriptRunner for that.

Darren Mason_oi1srw · Answer

I don't think JQL can go look/check a Linked Issue and check its status, it can only look at the filtered issues unless you know a way it can?