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

I want to create an automation based on the time a task has been in certain column

Hi,

I want to send a message to the channel once a task has been in a column for more than 3 days. I know there is a field called [Chart] Time In Status that is displayed in the card, but how can I access that field to make a comparison in my condition? 

The condition I want is if [Chart]Time in Status > 3

Then  send message to slack and message to assignee.

 

Thank you for the help

Jorge

 

1 answer

Hi Jorge,

in jql you can check whether a status has changed.

For your case you probably want something like this:

project = "your project"

AND NOT status CHANGED AFTER startOfDay(-3d)

AND created < startOfDay(-3d)

That gives you all issues which were not moved to another status within the last 3 days. You also need to exclude all issues that were created during the last three days since they haven't moved either.

Hope this helps.

Cheers,

Holger

Suggest an answer

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

New to Jira Automation - goodbye Cron (sort of), hello new project created trigger, new additions to

Hey Everyone! Simeon from the Automation team here. I'm delighted to share some new features and improvements that we are shipping to Jira automation (Cloud only). Firstly, @Sam Harding&nbsp...

2,823 views 10 23
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