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

Adam LaCoste March 15, 2024

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

2 answers

1 accepted

2 votes
Answer accepted
Stephen Wright _Elabor8_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 15, 2024

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 March 15, 2024

Thank you @Stephen Wright _Elabor8_ , 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.

1 vote
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 15, 2024

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 March 15, 2024

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 15, 2024

Hello Adam,

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events