I am setting up an automation that:
- Lookup Issues
- Send an email that have the table referring to issues' custom fields but the expected output to be in a table format of 6 columns - 1 column is issue.summary and the rest is issue.customfield:
<p>{{#lookupIssues}}{{/}}</p>
<table style="border-collapse: collapse;" width="100%">
<tbody>
<tr>
<th style="border: 1px solid #000000; background-color: #cdcaca;" valign="middle">Code</th>
<th style="border: 1px solid #000000; background-color: #cdcaca;" valign="middle">Tên Xét Nghiệm</th>
<th style="border: 1px solid #000000; background-color: #cdcaca;" valign="middle">Giá Walkin Cũ (Old)</th>
<th style="border: 1px solid #000000; background-color: #cdcaca;" valign="middle">Giá Doctor Cũ (Old)</th>
<th style="border: 1px solid #000000; background-color: #cdcaca;" valign="middle">Giá Walkin Mới (New)</th>
<th style="border: 1px solid #000000; background-color: #cdcaca;" valign="middle">Giá Doctor Mới (New)</th>
</tr>
<tr>
<td style="border: 1px solid #000000;" align="center" valign="middle">{{issue.customfield_10704}}</td>
<td style="border: 1px solid #000000;" align="center" valign="middle">{{issue.summary}}</td>
<td style="border: 1px solid #000000;" align="center" valign="middle"><a href="{{customfield_10744}}">{{issue.customfield_10744}} </a></td>
<td style="border: 1px solid #000000;" align="center" valign="middle"><a href="{{customfield_10745}}">{{issue.customfield_10745}} </a></td>
<td style="border: 1px solid #000000;" align="center" valign="middle"><a href="{{customfield_10664}}">{{issue.customfield_10664}} </a></td>
<td style="border: 1px solid #000000;" align="center" valign="middle"><a href="{{customfield_10665}}">{{issue.customfield_10665}} </a></td>
</tr>
</tbody>
</table>
However, only 1 issue is show in the email (1 row) even though as I check the audit log, the query found 2 issues.
If anyone can provide some insights or hints to help, please let me know
Thanks for your attention.