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!


Custom field and due date email notifications


Two questions I'm needing some assistance with please.

1. I have set up four custom fields in my company-managed JWM projects to show participants of a task (participant #1 through to #4).
I am wanting to create a rule to email users who have been added as participants but for the life of me can't make it work.

2. I'm trying to create a rule to send an email to task assignees the day before (or day of) a task due date. I get so far until i try to publish and it states:



  • The rule has been configured with components that require issues to be provided by the trigger. You need to use the option to run JQL to provide issues. The following components require issues: Issue condition


Please can someone give me the JQL?

Anytime i enter something like [duedate < now() and resolution is empty] or dueDate >= startOfDay AND <= endOfDay it tells me the same error message: 


Invalid JQL


Error in JQL Query: Expecting either a value, list or function but got ')'. You must surround ')' in quotation marks to use it as a value. (line 1, character 14)


I seriously can't believe how complex it is to get simple email notifications set up for field changes or due date approaching - it's wild it's so complex!

Thanks in advance,


1 answer

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Feb 22, 2023

Hi Lauren,

Try: project = ABC and duedate < startOfDay() and statusCategory != Done

Validate the query before you save so that you know you don't get an error, even if it returns 0 issues. Then you should be able to publish. 

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events