Automation rule to send reminder comment

[rajeswari saravanan]

Hy ! !! Iam expecting an automation rule jql to send notification comment for with customer .One query regarding it, I need to send a reminder comment on 4th day and resolving comment on 7th day but it should be running only on weekdays not on Weekends.(Mon-Fri).How it can be achieved as sometimes 4th day may fall on weekends,Can You please suggest how the jql can be configured in this situation.

We need to send exact comment as your ticket is waiting for 4days.Any suggestions 

[Ste Wright · Accepted solution]

Hi @rajeswari saravanan 

There's no native feature for this; you could try to use JQL to replicate this though - although it can get quite complex.

There's a suggestion for this here you could vote for/watch, but it is 13 years old - see: https://jira.atlassian.com/browse/JRASERVER-22506

---

Do you have Automation in your instance? 

You could create some additional metadata using Automation - eg.

• Put the last updated date's day into a text field, then use that in the JQL to make the queries easier - eg.
  
  • If it's Monday, go back 6 days (weekend + 4 days)
  • If it's Friday, go back 4 days (4 business days)
• Create a number field, and have Automation +1 to the field each day an issue remains open and not updated, exempting weekends and other non-working days. You could then just use that field in JQL instead

---

If you don't have Automation, I'd consider looking for an App from the Marketplace which can assist - either an automation/scripting app to replicate the above, or an app which can help you directly with the notifications based on business days.

Ste

[Antuan Sammak]

Hi @rajeswari saravanan 

I agree with Stephan that Automation would be your best option here, i recommend using {{now.plusBusinessDays(1)}} or {{now.minusBusinessDays(1)}} that will not count the weekend and will follow your Jira setup in terms of business days.

more information about using the above smart values and other similar ones can be found here https://confluence.atlassian.com/automation/jira-smart-values-date-and-time-993924864.html