How can I use Jira Cloud Automation to send a single email of linked issues in a table

[Adam LaCoste]

Hi All, I am hoping someone can help me with generating a single email with a table of linked issues.  

[Ste Wright · Accepted solution]

Hi @Adam LaCoste 

I tried this, which worked for me.

Ensure you do not include JQL in the Scheduled trigger, otherwise the rule iterates over each result and executes multiple times.

• Trigger: Scheduled
  • Run rule every = 1 Days
• Action: Lookup Issues
  • JQL - created >= startOfDay()
• Action: Send Email
  • Subject = List Of Issues
  • Content = ...see below

---

<h1 style="padding: 10px;">Daily Report</h1>

<table border="1">
<tr style="background-color: lightgrey;">
<th>Key</th>
<th>Summary</th>
<th>Status</th>
</tr>

{{#lookupIssues}}
<tr style="height: 50px;">
<td><a href="{{url}}">{{Key}}</a></td>
<td>{{summary}}</td>
<td>{{status.name}}</td>
</tr>
{{/}}

</table>

---

Some notes...

• The rule is an example, so will need JQL specific to your need.
• Likewise, the HTML is just an example - will need more information if you need specific help!
• <a href="{{url}}">{{Key}}</a> is producing the URL-linked Key.

Ste

[Adam LaCoste]

Thank you @Ste Wright , that worked.  

• The scheduler JQL solved the duplication
• Not sure what was going on the {{url}} but its working now
• The styling issues were because of the "Convert line breaks to HTML line breaks" checkbox that I did not see initially under the "More options" panel.

Very much appreciated.

[Trudy Claspill]

Hello @Adam LaCoste 

Please provide more information about what you are trying to accomplish.

There are many ways to generate an email with information about issues. My question is exactly what issues are you trying to include and what information from those issues?

You said you want "linked issues". Issues linked to what? 

[Adam LaCoste]

Hi @Trudy Claspill , thank you for your quick response.  Sure.

I have been successful at:

1. Creating the lookup from JQL
2. Generating the email
3. Creating a table structure using html in the email body
4. Pulling the smart values into the table

I have been unsuccessful at:

1. Producing a single email - the rule generates an email for each lookup issue
2. Link the issue key to the corresponding issue in Jira - not to be confused with Jira linked issues.

Would be nice to have:

For some reason I have been unable to apply styling to the table (row height being the biggest one).  The email appears to be ignore the style attributes. 

[Trudy Claspill]

Hello Adam,

Please show us your complete rule and the details of each step. Obscure confidential information.