Create template and JQL query to send emails when ETA approaches and when ETA is missed

[Zhivko Zhelev]

Hello all,

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 the following 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()>

I've been advised the following:

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.

However, I am not able to find a way to set templates in ScripRunner nor 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?. Also any advise on JQL query will be appreciated.

Thanks!

[Patty Land]

Hi Zhivko,

Do you also have access to Automation for Jira? Although it's true that ScriptRunner can easily accomplish this, Automation can be a lot simpler than ScriptRunner if you're not accustomed to writing your own Groovy scripts, as Automation handles all of this through an easy to use UI. If you have Automation, I could guide you how to set this up.

[Tech Support E-Comprocessing]

Hey Patty,

Thanks for your answer and sorry for the delay.

Indeed I have access to automation rules in Jira and I will be more than happy to receive your instructions.

Regards,

Zhivko

[Tech Support E-Comprocessing]

Hello Patty,

Can you please guide me with the automation?

Regards,

Zhivko