Hi,
Can anyone help me? I am trying to make a project automation that can detect if the ticket was created during off office hours and on week ends it will automatically send an email to the reporter saying that the ticket will be billed because it was not created during office hours. Can anyone enlighten me on the query and the trigger to be used?
Thank you.
I would use Scheduled automation (https://support.atlassian.com/jira-software-cloud/docs/automation-triggers/ - Scheduled chapter) to run query every midnight with query
"(created >= startOfWeek() AND created <= startOfWeek(5d) AND (created < startOfDay(8h) OR created > startOfDay(16h))) OR (created >= startOfWeek(6d) AND created <= startOfWeek(7d))"
I hope the query is correct but I didn't test it much. I will try to describe it a little. In first part the query should return issues which were created after start of week and before end of friday (startOfWeek(5d)). "created < startOfDay(8h) OR created > startOfDay(16h)" will return issues only if it was created before 8:00 OR after 16:00. Second part of query is intended for issues created on weekends.
Test it and let me know if there are any problems.
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.