Configure Email alert 2 day's before "Due Date" Based on Jira Transtion

Question

We have 3 workflow transtions in our Jira workflow. Following are the 3 transitions -

Production Incident Occurred

Initial Analysis Started

Initial Analysis Completed

Now we need to send email alert 2 day's before "Due Date" if anybody do not complete "Initial Analysis Completed" transtion.

We have configure "Escalation service" From Builtin Script Runner. In the Escalation Service we have put following line in "Additional Issue action" Section -

"issueInputParameters.setComment('The issue is not updated for last 7 days...Please take necessary action on it')"

and set JQL Query "status = Open and project = "Project Name" and updated < -7d"

So a comment has been generated 7 days prior automatically if the issue not updated.

Right now we need to send email regarding this instead of comment.

Can you please help us how can we configure this ?

Sys Admin · Answer

We understand. Thank you. We will test and let you know

Henning Tietgens · Answer

Your search should be something like

status != "Initial Analysis Completed" and duedate < endOfDay(7)

You will get all issues which are not in status Initial Analysis Completed and where the due date is before end of today + 7 days. If you want the assignee to get the email you add

and assigne = currentUser()

If the reporter should get the email you add

and reporter = currentUser()

If you create a subscription for this filter (see link in my answer) for a group of all potential users (e.g. "jira-users", but a smaller group would be better) the system does this search for every user and if it finds matching issues the user will get an email with all matching issues.

Sys Admin · Answer

Hi Hennings,

I have not quite understand if we configure subcription how Jira send mail automatically if any issue staus not updated for 7 days based on only "Due date" or send mail 7 days prior to due date

Regards

Sumit