Automated Emails

[Amanda Sugatan]

We created a JIRA automation rule to run in the morning and send an email when a custom field 'date' is passed the date. Here' the JQL: 

project = "DCR" and "PROD Due Date" > 1 and "Status" != "DONE"

project = "DCR" and "QA Due Date" > 1 and "Status" != "DONE"

When I validated the rule, 10 issues are found. However, I received 7 emails, for each custom field JQL, and the dates passed are note the same. 

Would anyone have an idea why we are receiving so many emails?

Is it possible to customize the emails to display which issues are being found? If yes, is it possible to send an email to specific watchers based on their custom field status?

Thanks for all of your help! :)

[Bill Sheboy]

Hi @Amanda Sugatan -- Welcome to the Atlassian Community!

The reason you are receiving so many emails is the JQL is in the Scheduled Trigger, and that will process an email for each issue found.

When you want to send one email containing a list of issues meeting the criteria, please try:

• use a Scheduled Trigger with no JQL
• use the Lookup Issues action with the JQL
• filter down to what is needed, and branch to send the details using additional Lookup Issues actions

Here is an article from Atlassian that outlines the steps, which can be modified for the specifics of your scenario: 

https://confluence.atlassian.com/jirakb/automation-to-send-email-only-once-per-assignee-1310985609.html

Kind regards,
Bill