A table using Jira email notification set in the Jira automation

Vera Valshonok
Contributor
July 20, 2023

Hi All!

I have created a Jira automation to update a person, send him email when the tickets Warranty end date shows that the warranty will end withing 45 day.

Currently the email only shows a list of links and Keys of the tasks that match this condition. 

I am trying to make it possible so that the automation will send an email with the Table in it including specific fields from the task and with the field information in these fields.

Here's example of what I wrote till now, but it does not work and does not create a table. 

Maybe you can advise how can I fix it?

Please see the list of the assets below. These assets warranty expires within 45 days.

<table>
<tbody>
<tr>
<th>Ref</th>
<th>Title</th>
<th>Site Name</th>
<th>System Device Type</th>
<th>System Device Vendor</th>
<th>Serial Number</th>
<th>Warrant end date</th>
<th>Summary</th>
</tr>
{{#issues}}
<tr>
<td>{{key}}</td>
<td>{{summary}}</td>
</tr>
{{/}}
</tbody>
</table>

1 answer

0 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 24, 2023

Hi Vera,

Use {{issue.field name}} for each of the fields. But the field name must be exactly has the field is created, including case sensitivity. 

For example {{issue.Serial Number}} {{issue.Seystem Device Type}}

Vera Valshonok
Contributor
July 24, 2023

@John Funk 

 

sorry, a bit confused where I should add into my code above? Can you show me copy pasting mine here and where I would need to add the fields you suggest and specific field names that I would add afterwards?

That might clarify it for me and would be very helpful. Thanks!

Like John Funk likes this
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 25, 2023

In the body of the text that you have above. Can you share the entire automation rule that you have so far? 

Vera Valshonok
Contributor
July 26, 2023
Like John Funk likes this
Vera Valshonok
Contributor
July 26, 2023

Screenshot 2023-07-26 154656.png

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 26, 2023

So, did you put in in the Subject? Sorry, but this screenshot is still incomplete. 

Vera Valshonok
Contributor
July 26, 2023

@John Funk 

Please see the list of the assets below. These assets warranty expires within 45 days.

 

{{#lookupIssues}} *{{key}}*:

{{summary}}: {{url}}{{/}}

 

<body>

<h4>Report table</h4>

<table>

<tr>

<th>{{#lookupIssues}} *{{url}}*:</th>

<th>Summary</th>

<th>Site name</th>

<th>System Device Type</th>

<th>System Device Vendor</th>

<th>Serial Number</th>

<th>Warranty End date</th>

 

</tr>

<tr>

<td><a href="URL_TO_Key">Summary</a></td>

<td>80%</td>

<td>100</td>

<td>02:30:00</td>

<td>80</td>

<td>20</td>

</tr>

</table>

</body>

</html>

Vera Valshonok
Contributor
July 26, 2023

I am adding code to the Automation for sending email  notification

Suggest an answer

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

Atlassian Community Events