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; } } }

Multiple Tables in an Automated Email One Does Not Format

Tom Scoggin

I have about 4 or 5 tables that are rendered in an automated email. The tables are based on status. Everything works perfectly except the Status for Done. That table does not render correctly. I pulled the code and ran it using the status id for Done and then ran the exact same code with the id for To Do.

When I changed it to the To Do status id the table rendered correctly. With the same code using the id for Done it does not render correctly. I know I have the correct id because I put the field in the table.

Any thoughts why Done renders incorrectly but the other tables work fine?

Accepted answers

All comments

Brant Schroeder

@Tom Scoggin Can you share what you are using to render the tables in your automation? Can you share a screenshot as well?

Tom Scoggin

This is the code. As you can see I'm having trouble keeping each table format consistent in the email.

Tables image.JPG

<table>
<tbody>
<tr>
<th Style="width:80px">Issue Type</th>
<th Style="width:80px">Issue Key</th>
<th Style="width:125px">Title</th>
<th Style="width:90px">Created</th>
<th Style="width:90px">Updated</th>
<th Style="width:180px">Status</th>
<th Style="width:50px">Unit</th>
<th Style="width:400px">Last Comment</th>
<th Style="width:75px">Days Since Last Update</th>
</tr>

{{#if (status.id.eq(10000))}}
<tr>
<td>{{issueType.name}}</td>
<td>{{key}}</td>
<td>{{summary}}</td>
<td>{{created.format("MM/dd/yyyy")}}</td>
<td>{{updated.format("MM/dd/yyyy")}}</td>
<td>{{status.name}}</td>
<td>{{CPT}}</td>
<td>{{comments.last.body}}</td>
<td>{{updated.diff(now).days.abs}}</td>
</tr>
{{/}}
{{/}}
</tbody>
</table>

<br>
In Progress Table<br>
<br>

{{#issues}}
{{#if (status.id.eq(3))}}
<tr>
<td>{{issueType.name}}</td>
<td>{{key}}</td>
<td>{{summary}}</td>
<td>{{created.format("MM/dd/yyyy")}}</td>
<td>{{updated.format("MM/dd/yyyy")}}</td>
<td>{{status.name}}</td>
<td>{{CPT}}</td>
<td>{{comments.last.body}}</td>
<td>{{updated.diff(now).days.abs}}</td>
</tr>
{{/}}
{{/}}
</tbody>
</table>

<br>
Pending External Action<br>
<br>

{{#if (status.id.eq(12737))}}
<tr>
<td>{{issueType.name}}</td>
<td>{{key}}</td>
<td>{{summary}}</td>
<td>{{created.format("MM/dd/yyyy")}}</td>
<td>{{updated.format("MM/dd/yyyy")}}</td>
<td>{{status.name}}</td>
<td>{{CPT}}</td>
<td>{{comments.last.body}}</td>
<td>{{updated.diff(now).days.abs}}</td>
</tr>
{{/}}
{{/}}
</tbody>
</table>

<br>
Awaiting Parts<br>
<br>

{{#if (status.id.eq(11441))}}
<tr>
<td>{{issueType.name}}</td>
<td>{{key}}</td>
<td>{{summary}}</td>
<td>{{created.format("MM/dd/yyyy")}}</td>
<td>{{updated.format("MM/dd/yyyy")}}</td>
<td>{{status.name}}</td>
<td>{{CPT}}</td>
<td>{{comments.last.body}}</td>
<td>{{updated.diff(now).days.abs}}</td>
</tr>
{{/}}
{{/}}
</tbody>
</table>

{{#if (status.id.eq(10001))}}
<tr>
<td>{{issueType.name}}</td>
<td>{{key}}</td>
<td>{{summary}}</td>
<td>{{created.format("MM/dd/yyyy")}}</td>
<td>{{updated.format("MM/dd/yyyy")}}</td>
<td>{{status.name}}</td>
<td>{{CPT}}</td>
<td>{{comments.last.body}}</td>
<td>{{updated.diff(now).days.abs}}</td>
</tr>
{{/}}
{{/}}
</tbody>
</table>

Brant Schroeder

If you use old-school table formatting like this does it work?

<table>
<tbody>
<tr>
<th width="80">Issue Type</th>
<th width="80">Issue Key</th>
<th width="125">Title</th>
<th width="90">Created</th>
<th width="90">Updated</th>
<th width="180">Status</th>
<th width="50">Unit</th>
<th width="400">Last Comment</th>
<th width="75">Days Since Last Update</th>
</tr>

{{#if (status.id.eq(10001))}}
<tr>
<td width="80">{{issueType.name}}</td>
<td width="80">{{key}}</td>
<td width="125">{{summary}}</td>
<td width="90">{{created.format("MM/dd/yyyy")}}</td>
<td width="90">{{updated.format("MM/dd/yyyy")}}</td>
<td width="180">{{status.name}}</td>
<td width="50">{{CPT}}</td>
<td width="400">{{comments.last.body}}</td>
<td width="75">{{updated.diff(now).days.abs}}</td>
</tr>
{{/}}
{{/}}
</tbody>
</table>

Brant Schroeder

Also what email client are you using? (Outlook, Gmail) I want to try and recreate it.

Bill Sheboy

Hi @Tom Scoggin

Looking at what you have posted, I wonder: are you doing this in an Automation for Jira rule or by some other automation mechanism?

And, are you using Jira Cloud, not the Server or Data Center versions?

If so, I recall a conversation with Atlassian Support from a couple of years ago that the {{issues}} smart value is not supported for Cloud, only for Server / Data Center versions. The context of that support call was why not all fields / data were supported in {{issues}}...it is because it is a coincidence / accident the smart value is visible in Cloud, but the contents are not defined / documented for Cloud.

Instead either Lookup Issues or a web request response message are used for bulk-handling of issue data.

Kind regards,
Bill

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