JSM automation to send email based on JQL query

[trthomas]

I have an automation rule set up to run every morning at 9:00 AM.  It should be looking at a JQL query that I have set up and send out an email if there is a ticket created that matches the query.  

It was working great, sending out an email a day before the date in the custom field I have set up.  But something has changed and now it sends out an email every day at 9:00 AM if the ticket is created that matches the query, not looking at the part of the query that specifies it must be 1 day before the custom date. 

Here is the query. 

Project = SD AND "Reason for Request[Dropdown]" = "Workday problem or suggestion" AND "Planned Start" >= startOfDay(1)

I've tried adjusting the date portion of the query, but it doesn't seem to matter.  Do you have any thoughts on what is now wrong with the query and how I might be able to fix this?

[Laurie Sciutti]

Hi @trthomas ~ have you clicked the "Validate query" button to show the results?  That is usually a good first step to determine if the expected issues are included and may give you insight as to the problem...

[trthomas]

Yes, I have validated my query and it is valid, returning 1 result (1 ticket found that matches the criteria).