nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Ste Wright

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

All comments

Trudy P 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 P Claspill , thank you for your quick response. Sure.

I have been successful at:

Creating the lookup from JQL
Generating the email
Creating a table structure using html in the email body
Pulling the smart values into the table

I have been unsuccessful at:

Producing a single email - the rule generates an email for each lookup issue
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 P Claspill

Hello Adam,

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

Ste Wright

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud