You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I've done some research and found a few answers but can't seem to get my automation to run without errors.
I want to program Jira to send an email 7 days before the due date as a 7 day out reminder. I have it scheduled to run every day in the morning, what should my JQL entry be for the custom field "due date"?
You would add this to your JQL to get issue that are due 7 days out:
due = 7d
Another option to do it is to use smart values to see if the due date is 7 days out, similar to this automation that I have that sends a reminder 90 days out:
The reason I'm using smart values is because the due date is not required and there are issues in the project that should not get the notification.
Adding to Mikael's answer:
To whom are you sending this notification?
I ask that question because if you are sending this just to yourself, you may want one email that day, versus an email for each issue. Similarly if you are sending emails to assignees, they may want to only see their issues, not everything due 7 days out (possibly for other assignees).
You may adjust your rule accordingly if you want to handle these cases, using rule components like branching and the Lookup Issues action.
Brandi, your rule could be something like below. Please compare it to what you have to help identify the cause of the errors.
First, Mikael gave you a good start for that JQL. You may add to it with:
project = yourProjectName AND due = 7d
You may add other conditions as needed.
Next, as you describe being new to Jira, you may want to look at the free training from Atlassian on writing JQL:
And after that, look at the more advanced features: