Scheduled Automations

Question

Hello,

I am trying to create an automated email that is scheduled to run weekly. I want to get all Open issues and send one email with information related to these issues.

I was able to create the email successfully, but the issue is that one email is generated for each of the issues (for example, if there are two open issues, two emails are triggered). My goal is to send only one email for all open issues, but get the list of all issues in the same

Is it achievable without using any JS and just through simple automation rules? I am also attaching the sample format below

-Jishnu

Matthew Kijula · Answer

Thank you both @Bill Sheboy @J_ Caldwell

J_ Caldwell_ovdw7z · Answer

Would say the following ->

1) I'd start your own thread next time.

2) The problem is listed in the error. Your trigger is time based, not issue base, so there is nothing to "query" in the way you have done it. You would either need the trigger to be based off something relating to the issue (e.g transition, create, edit, etc.) or if you are looking to do something like "every Weds at 9am, search for these issues and then email me if there is more than 0 found" -> I'd say that you should be doing that with a filter and subscription -> that would serve you better more than likely.

Bill Sheboy · Answer

Hi @Matthew Kijula -- Welcome to the Atlassian Community!

That error is stating the problem: there are no issues to process because the trigger did not provide them.  Normally the rule editor gives a warning for actions stating there are no issues available, but apparently that is not showing for conditions.

When using the Scheduled Trigger, you may use it with or without JQL.  When you add JQL, the rule finds the issues and runs once for each issue found.

If you want one email for each issue, you could combine all of those conditions into the JQL, changing the rule to this:

* trigger: Scheduled, with JQL

project = "LOV (LOV)"
 AND status != Done
 AND "QA Due Date" > -1d

* action: Send email

If you want to send one email for all of the issues, try using the Lookup Issues action instead:

* trigger: Scheduled, with no JQL
* action: Lookup Issues, with the same JQL from above
* smart value condition:* first value: {{lookupIssues.size|0}}
* condition: greater than
* second value: 0

* action: Send email, listing the issues with a list iterator

{{#lookupIssues}}
* {{key}} -- {{summary}}
{{/}}

Kind regards,
Bill