Send Email when Open tickets in Given Project exceeds 10

Question

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?

Valerie Knapp_dpp5c6 · Answer

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

Zalesak, Stacy M · Answer

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_dpp5c6 · Answer

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