Hello - I'm trying to set up an automations rule that checks for the difference between the date time NOW, and when issues were last updated (with corrections for time zone).
If the time difference meets a certain threshold (3 business days) then the conditions match. When the conditions match, send an email. When the email is sent, it would also log an update in the issue field, resetting the "difference" clock. This would be a scheduled automation daily.
There are 2 areas where I am confused:
1) What would the advanced compare condition in the automation look like? I have set it up this way, however I am not sure if this is correct:
{{now.diff(issue.updated).convertToTimeZone("America/New_York").businessDays}}
is less than -3
2) When I save the automation as a Scheduled Automation, I get the following error:
What do I put in the JQL query below the Schedule, as shown below?
I assumed it would be something like:
{{now.diff(issue.updated).convertToTimeZone("America/New_York").businessDays}} < -3
But that is returning an error.
Any assistance on this would be much appreciated!!! Thank you.
I have made some adjustments and I think I have resolved the problem:
1) I updated the first value in the Advanced compare condition to
{{now.diff(issue.updated).businessDays}}
2) I removed the business days check from the JQL query located on the Scheduled automation, and instead updated it to just look for issues with a Status of "Waiting for Approval" as so:
Status = "Waiting for Approval"
...as this only pulls in the issues that I want to put through my advanced compare condition in 1).
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.