Custom field and due date email notifications

[Lauren Kirt]

Hello,

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:

 Error

• 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,

Lauren

[John Funk]

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.