Automation for Weekend

Question

Hello, we have a JQL statement for our weekend oncall tickets however some appear to not hit the criteria necessary. Wondering if this statement is correct for reaching all tickets on Saturday & Sunday.

{{#=}}({{now.convertToTimeZone("America/New_York").dayOfWeek}} > 5) && ({{now.convertToTimeZone("America/New_York").dayOfWeek}} < 7){{/}}

Kind Regards

Morgan Knicely · Answer

Here is your original expression, updated to correctly identify Saturday and Sunday.

{{#=}}({{now.convertToTimeZone("America/New_York").dayOfWeek}} = 6) || ({{now.convertToTimeZone("America/New_York").dayOfWeek}} = 0){{/}}

dayOfWeek begins with 0 on Sunday, so Saturday is 6.

Our company is global so I had to check for time in addition to day of week. I started with your A4J expression and modified it to identify events occurring after 02:00 UTC Saturday and before 22:00 UTC Sunday. Our server runs on UTC time so I did not need to convert timezones.

Trigger: Issue Created

Filter: Advanced Compare Condition

{{#=}}
({{now.dayOfWeek}} == 6 && {{now.isAfter(now.withHour(2).withMinute(0).withSecond(0).withMillis(0))}})
||
({{now.dayOfWeek}} == 0 && {{now.isBefore(now.withHour(22).withMinute(0).withSecond(0).withMillis(0))}})
{{/}}

is greater than 0.

Translated to human...

Now is Saturday after 02:00 or now is Sunday before 22:00.

Italo Qualisoni [e-Core] · Answer

Can you try this condition instead? This will check if the current day is either Saturday or Sunday in the NYC timezone.

First value: {{now.convertToTimeZone("America/New_York").dayOfWeekName}}

Condition: contains regular expression

Regular expression: (Saturday|Sunday)

I encourage you to also use a log action(see in my image the component under the condition), you can use this to check the {{now.convertToTimeZone("America/New_York").dayOfWeekName}} value in the audit log in execution and it can help you to check the value of your smart value.

Hope this helps!

Kadeem Samuel · Answer

Thank you for replying Sudarshan, I will give that change a shot over the weekend to see how it responds.