Create rulo for sending emails

[Zhivko Zhelev]

Hello everyone,

We have the following request from our PD department and we are looking for solution:

The development team keep on forgetting to update the ETA´s of items in a timely manner. I would like to formalize a process where 2 email notifications are sent every day to every developer, if there are tickets matching that criteria:

• Subject:  Upcoming ETA on Jira items
  Text:  Dear „User“, you have tickets assigned to you with ETA fast approaching, as listed below.  Please ensure that the data in there is correct, and if not, update it to your best current estimate and describe why that is needed. <followed by the list based on a Jira query like:  assignee = "XXX" AND status in (TODO, "IN DEVELOPMENT", ACCEPTED, PENDING, "IN ANALYSIS", "SUBMITTED FOR REVIEW", "In Progress", "Ready For Development", "WAITING FEEDBACK") AND "Estimated Date of Arrival (ETA)" >= "0" AND "Estimated Date of Arrival (ETA)" <= 2D AND "Release Cycle" in openSprints() >
• Subject:  Expired ETA on Jira items! – Action Required (Priority High)
  Text:  Dear „User“, you have tickets assigned to you with an ETA in the past.  As per our Product Development Process the ETA is required to be valid at all times, indicating the best possible estimate of when an item can be expected to be completed, and that can not under any circumstances be in the past.  If you have little to no information yet, please indicate that with a comment in the ticket and put a future date where there is at least some chance it may get done by.  <assignee = "XXX" AND status in (TODO, "IN DEVELOPMENT", ACCEPTED, PENDING, "IN ANALYSIS", "SUBMITTED FOR REVIEW", "In Progress", "Ready For Development", "WAITING FEEDBACK") AND ("Estimated Date of Arrival (ETA)" < endOfDay() AND "Estimated Date of Arrival (ETA)" != "2000/01/01") AND "Release Cycle" in openSprints()>

Do you think there is any possibility for this to happen? We are using ScriptRunner for other functionalities, but maybe it can be used for this purpose as well?

Thanks,

Zhivko

[Craig Nodwell · Accepted solution]

Hi @Zhivko Zhelev if you have scriptrunner this can be easily achieved.  You could setup your email templates, include JQL in it and send these out on scheduled jobs.

[eMerchantPay IT]

Hey Craig,

Thanks for the tips.

I did not find any useful information on how to create templates using ScripRunner in their documentation https://scriptrunner.adaptavist.com/5.6.8/jira/builtin-scripts/ for this specific scenario, can you help here?

Thanks!

Zhivko