I am trying to exclude certain status from email notifications that I have setup.

[James Shaw]

Hi All,

I hope you are all well.

I am new to Jira and especially JQL so I am not 100% sure how I would go about doing this. I followed this guide: https://community.atlassian.com/t5/Jira-questions/Email-notification-to-an-Assignee-based-on-Due-Date-of-an-Issue/qaq-p/823008 using this bit of code:  assignee = currentUser() AND (due < now() OR due = 1d)

Everything works as it should but in those emails, I can see tickets that where done from like several days ago which is not what I want, I only want open tickets due within 24hours so basically I need exclude all these status types in the above code but as I am new, I would know how I could include them.

status IN ("Done","Duplicate","Resolved","Invalid","Already fixed") ORDER BY created DESC

If anyone is willing to assist, I would greatly appreciate the assistance :)

Kind Regards,

James

[Панской Андрей · Accepted solution]

due < now() OR due = 1d - this JQL show you overdue and issues due tomorrow. To get only issues due tomorrow, you need use due = 1d JQL.

To exclude issues with some statuses use status NOT IN ("", "", ...) construction.

Full JQL will be as follows: assignee = currentUser() AND due = 1d AND status NOT IN ("Done","Duplicate","Resolved","Invalid","Already fixed") ORDER BY created DESC

[James Shaw]

I really appreciate the help, that has worked a treat thank you!