Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

Create an alert automation when ticket stuck in a column

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

 

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

1 answer

1 accepted

0 votes
Answer accepted

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

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)

 

Please try instead adding:

AND labels IN ("iOS", "Android", "Back")
Like Sandra Kabamba likes this

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

Like Bill Sheboy likes this

I am glad to learn that is working.  Please consider marking this question as answered; that will help others with a similar need in the future find solutions faster.  Thanks!

Like Sandra Kabamba likes this

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

323 views 1 5
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