Single email with changed issues per proejct for Scheduled Automated Global Rule

Spiros P.

It is probably been asked somewhere. But I search and only find similar answers.

I created a scheduled rule which will run every 3 days and for a start will add organizations to issues for multiple projects that have the field emtpy. Rule goes like this for now:

When: Scheduled
project = "A" OR project = "B" OR project = "C"

If: all match
project = "A" (JQL)
Organizations is empty  (Issue Fields condition)

Then: Edit issue fields
Organization set to "A name"

Else if: all match
project = "B"
...

Else if: all match
...

At the end I want to add:

Then: Send email 
And receive a single email that lists all changed issue's per project. 

I am willing to extend the above rule to make several changes in the future, where I will need to be informed of the outcome but without receiving "100" different emails.

From what I have been reading here is more or less what I imagine I would have to add to the email body to achieve this:

blah blah..

<ul>
{{#lookupIssues}}
{{issue.project.name}}
<li><p><a href="{{url}}">{{key}} | {{summary}}</a>: {{Organizations.name}}</p>
</li>
{{/}}
</ul>

Is this correct or close? Can it be done?

I hope my question is clear.

Thanks in advance.

Alex Koxaras -Relational-

Geia sou Spiro!

Interesting automation you got there! You are not far from making your rule working. You've got almost everything figured out! However, the one tiny little piece that's missing is the lookupissue action, which you must place after the trigger. Please find below my rule, with slight modifications (to trigger, one project scoped etc):

 

Now this rule was built only for a single project, but of course you can add you else statements after the first if. Keep in mind of the limits you have when executing rules across multiple projects.

• Trigger: you schedule it as you wish
• Lookupissues: You have to add the action, in order to send that email afterwards. What it does is that it searches for all issues which meet certain criteria (search yields results up to 100)
• IF/ELSE: You add and separate your edit field, for each project
• Send email: Outside of the IF/ELSE statement you add your email, just as you wrote it.

 

The only thing that was missing from your rule was the lookupissue. Ohh.. and you might need to modify the email HTML to be a bit more presentable (at least on my outlook client, it's not that presentable). Btw, in what plan do you have your JSM?

Let me know if that works!