E-Mail Automation for upcoming deadlines

Question

Dear community,

I am looking for the JQL code to send automated emails to the assigned Person, when an Epic, Task or Subtask is due in 2 days or less and not (status) done so far.

Goal is to remind my creative team on task that have to be done in the next two days in order to keep the delivery deadline. How do I need to structure the JQL in order to screen for all tasks AND subtasks, because the delivery deadline are sometimes different between them.

Thank you so much & Best

Jack Brickey · Answer

Hi @David Zander , The following JQL will return all issues of type task or sub-task that are due within two days or overdue based on the due date field.

type in (task, subtask) and duedate <= startOfDay(2) and statusCategory != done

The last part of your question is regarding notifying the assigning of their doom issues. I would recommend using automation for this and I recommend using the search bar here in the community to five semi posts as there are quite a few. However if you get stuck on the automation please let us know if we can assist

Mohamed Benziane · Answer

Hi,

you can try:

type in (task, subtask) and due <= 2d