Send a single email notification for unassigned issues

[John Cross]

I would like to use automation to send out an email at 9am each day as a reminder when there are any issues in a specific project that have not yet been assigned.

I have the basics working, but my problem is that an email is sent for each issue that is unassigned - I only want to send one email out.

The rule looks something like this:

[WHEN: 9am each day]
JQL: updated <= startOfDay(-1d) AND statusCategory != Done

[IF: all match]
Assignee = empty

[THEN: send email]

I have tried playing with entity properties but it seems to send multiple emails the first time and then never run again. I need it to run daily, but only send one email.

Any help appreciated!!

john

[Stephen_Lugton]

@John Cross rather than using automation for this you can use subscriptions on a filter.

So first off create a filter:

• updated <= startOfDay(-1d) AND statusCategory != Done AND assignee is EMPTY

Then under Filter Details add a subscription - you can either get everyone who you want to see the scheduled subscription notification to create a personal subscription, or you can create a group with everyone you want to receive the notification.

[Jacques]

I agree with @Stephen_Lugton ... Using a subscription is a much better solution than overloading automation with this. Some more details on filters and subscriptions can be found in this article.

[Duc Thang TRAN]

Hello @John Cross 

Here is my suggest : 

• You can add the condition directly to the JQL query: updated <= startOfDay(-1d) AND statusCategory != Done AND assignee is empty.
• For one mail with all issues : you can  use the "Lookup issues" action and with  associated smart values (more infos https://support.atlassian.com/cloud-automation/docs/jira-smart-values-issues/)
• like in this example : 

Hope this can help you