Jira Automation - Send an email with a list of unresolved issues by Epic

[Michael Offenbacher]

I am looking to create an automation in Jira that sends an email, on a scheduled basis, of all unresolved issues associated with an epic. Is this possible using Jira Automation?

As an example:

Epic Key - Epic Name

• Issue key - Issue Summary - Issue Status
• Issue key - Issue Summary - Issue Status
• ...

Epic Key - Epic Name

• Issue key - Issue Summary - Issue Status
• Issue key - Issue Summary - Issue Status
• ...

[Kseniia Trushnikova]

Hi @Michael Offenbacher,

I'm not sure if it's possible to group issues by Epics in an email. You can try this:

• Add the trigger Scheduled.
• Add the action Lookup issues with JQL "Epic link" is not empty and resolution is empty ORDER BY "Epic Link" to find issues and order them by Epics.
• Add the action Send email with such content:
  

<table>
<tbody>
<tr>
<th>Epic Key</th>
<th>Epic Name</th>
<th>Issue Key</th>
<th>Issue Summary</th>
<th>Issue Status</th>
</tr>
{{#lookupIssues}}
<tr>
<td>{{epic.key}}</td>
<td>{{epic.Epic Name}}</td>
<td>{{key}}</td>
<td>{{summary}}</td>
<td>{{status.name}}</td>
</tr>
{{/}}
</tbody>
</table>

Please uncheck the option Convert line breaks to HTML line breaks in the More options section.

This rule will send issues data in a table sorted by Epic link.