Automation Rules -> Condition or Cron Job?

[Deleted user]

Hello dear Community,

I need to do some automation for my board that changes the status of one column to another at a certain time and then sends an email to the recipient caring for the next status/column.

I've built a status called pending, which means that the issue is pending for 24h until the work finally should start. 

At least I've managed to put out the correkt date and time in an email, when pending status ends. Looks like this: 

{{now.plusDays(1).toBusinessDay().convertToTimeZone("Europe/Paris").format("dd.MM.yyyy 'um' HH:mm")}}

But how can I now let Jira change the status at this announced date and time automatically?

Has anybody an idea that helps me get further?

Thanks a lot for any suggestion!

Regards 

Dino

[Deleted user · Accepted solution]

Hi Bill,

thanks for your answer. The target date is {{now.plusDays(1).toBusinessDay()}}. I will look for the scheduled trigger. Former I thought of something with an {{if}} statement but didn't know how to campare these two values (target date & {{now}} ) and who checks this permenently. 

Concerning your curiosity, this was not my idea. Currently it works the way, that the last editor pushes the issue into the next status, but my colleagues working with this board, asked me to set it to the next step automatically after 24h. Seems there is a lot of capacity :-)

Thanks so far!

Regards

Dino

[Bill Sheboy · Accepted solution]

Hi @[deleted] 

I can think of two ways to do this, both using a scheduled trigger to periodically check for a condition...

1. If you can write JQL to detect the issue to transition, use that in the scheduled trigger and use an action to transition the status.
2. If you cannot represent the target date in JQL, when you create that email, save the date/time in a custom field.  Then compare that custom field to {{now}} to determine when it is time to transition.

Also, I am curious... this seems like pushing work onto someone in a new work step (status) rather than having them pull when they have capacity to do the work.  How likely is it they will always have capacity to do the new work?

Best regards,

Bill