How to exclude a specific date without using complicated Cron expressions in Automation for Jira

Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary

In Automation for Jira, you can configure the execution period with Schedule Trigger in the following ways;

“Advanced(CRON expressions)“ is popular when you specify a time. However, the configuration of “execute 9:30 AM to 10:00 PM from Monday to Friday every 15 minutes“ is difficult to express in a CRON expression.

1 // NG It works "9:00 AM", "9:15 AM", "10:00 PM", "10:15 PM", "10:30 PM" and "10:45 PM"0 0/15 9-22 * * MON-FRI *

You can also configure with multiple CRON lines in Linux, but “Automation for Jira“ is unable to configure with multiple CRON lines. You will need to separate Automation, but it will be complicated.

1 2 3 4 // "Automation for Jira" can't be setting in multiple lines 0 30,45 9 * * MON-FRI * 0 0/15 10-21 * * MON-FRI * 0 0 22 * * MON-FRI *
Automation rule scheduled trigger with cron expression

Solution

You can exclude the specified date by using Advanced compare condition.

Exclude specific time specified using cron by using advanced compare condition in Jira automation

Using the built-in functions “now”, you can get the current date and compare it with the condition, and you can exclude the specified date. Following these configurations, you can get the configuration “execute 9:30 AM to 10:00 PM from Monday to Friday every 15 minutes“.

CRON expressions

1 // CRON Expression: It works "9:00 AM", "9:15 AM", "10:00 PM", "10:15 PM", "10:30 PM" and "10:45 PM"0 0/15 9-22 * * MON-FRI *

Advanced compare condition

FieldValue
First Value{{now.convertToTimeZone("Asia/Tokyo").shortTime}}
Conditiondoes not match regular expressions
Regular expression(9:(00|15) AM)|(10:(15|30|45) PM)

(Tips)Audit Log

  • When Automation is successful, the status will be "SUCCESS"

  • When the Condition is rejected, the status will be "NO ACTIONS PERFORMED"

Automation audit logs

Updated on June 6, 2024

Still need help?

The Atlassian Community is here for you.