Send Email when Open tickets in Given Project exceeds 10

[Zalesak_ Stacy M]

Hi All,

I have a VP who oversees about 20 jira projects. He would like a daily email for each project when he project exceeds 10 open customer tickets (issuetype = l3).  If a given project has less than 10, no email is sent. Without having to create a separate automation for each project, how can i make this work?

I've gotten it to partially work, however when a given project exceeds 10 issues, it sends one email PER OPEN TICKET - not one email per project.  Any help would be appreciated. Can someone point out where i've gone wrong?

[Zalesak_ Stacy M]

I've seen these and this doesn't help in my scenario of trying to send one email per project IF a given project has over 10 open issues. Thanks though

[Valerie Knapp]

Hi @Zalesak_ Stacy M , welcome to the Atlassian Community and thanks for your post 

Please check out this post, which is trying to do something similar https://community.atlassian.com/t5/Jira-questions/Jira-Automation-Send-email-with-summary-of-issues/qaq-p/2914265 

I think these two articles mentioned will be helpful for you 

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

https://confluence.atlassian.com/jirakb/send-issues-in-a-single-email-structured-in-a-table-1384126906.html 

So here, you need to change from the assignee to another person but hopefully these links help you. 

If you have other questions or are still stuck, please write again. 

Best wishes

[Valerie Knapp]

Hi @Zalesak_ Stacy M , thanks for your feedback.

I have got this rule working -

Note: I have removed my email, but I had to try this in two different instances before I got it working so I can assure you, it does work. I just wanted to anonymise my email.

So, the trigger is scheduled, I didn't put any JQL in it.

Then I create the lookup issues, in this case, of a small project with 17 issues.

Then I set up an IF / ELSE condition block.

The IF condition is {{lookupIssues.size}} is greater than 10

Then I am logging the decision to send an email if the criteria is evaluated to be met

Then I am sending the email with the table of issues in it

{{#lookupIssues}}
{{key}}: {{Summary}}
{{/}}

Then, for the ELSE block, it's {{lookupIssues.size}} is less than 10

Then I am logging the decision not to send the email.

Please can you try this and see if it works for you?

Cheers