Hello, I would like to create an automation rule with 2 levels of alert * When a ticket stay more than 2 days on specific states (Blocked and code review) without any modification then the assignee is tagged on the comment section with a message * If tickets stay more than 4 days into a column the list is sent into a slack channel I tried to do it directly on the automation section but it seems that there's no action or trigger regarding time. Should use a JQL query? If yes, how to compose and integrate it into my board. Thanks by advance

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create an alert automation when ticket stuck in a column

Sandra Kabamba

Hello, I would like to create an automation rule with 2 levels of alert

When a ticket stay more than 2 days on specific states (Blocked and code review) without any modification then the assignee is tagged on the comment section with a message
If tickets stay more than 4 days into a column the list is sent into a slack channel

I tried to do it directly on the automation section but it seems that there's no action or trigger regarding time. Should use a JQL query? If yes, how to compose and integrate it into my board.

Thanks by advance

Accepted answers

Bill Sheboy

Hi @Sandra Kabamba

You may do what you ask with a scheduled trigger (perhaps checking daily) and a JQL statement to find the relevant issues. For example:

project = myProject AND NOT status CHANGED AFTER -2d AND status IN ("Blocked", "Code Review")

Kind regards,
Bill

All comments

Bill Sheboy

Hi @Sandra Kabamba

You may do what you ask with a scheduled trigger (perhaps checking daily) and a JQL statement to find the relevant issues. For example:

project = myProject AND NOT status CHANGED AFTER -2d AND status IN ("Blocked", "Code Review")

Kind regards,
Bill

Sandra Kabamba

Thanks @Bill Sheboy the query works great!

But I cannot exclude some labels or include some labels

project = myproject AND NOT status CHANGED AFTER -2d AND status IN ("Blocked", "In Review") AND labels ("iOS","Android","Back")

I've got an error message saying

Error in the JQL query: an operator is anticipated but '(' is mentioned instead. Valid operators are '=', '!=', '<', '>', '<=', '>=', '~', '!~', 'IN', 'NOT IN', 'IS' and 'IS NOT'. (line 1, character 122)

Bill Sheboy

Please try instead adding:

AND labels IN ("iOS", "Android", "Back")

Sandra Kabamba

Yes, it's working. Thanks a lot @Bill Sheboy

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud