Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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

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 for this specific scenario, can you help here?. Also any advise on JQL query will be appreciated.






1 answer

0 votes
Patty Land
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Oct 27, 2022

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.

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.



Hello Patty,

Can you please guide me with the automation?



Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events