Automation rule - send by mail a recap table with lookup issues

Garn_lgavks

Hi,

I'm using Jira Software (v9.4.8) Data center in my company. I'm administrator of my project, but not administrator of the full instance. 

I'm trying to use an automation rule to, by click, send a mail with a table containing all the issues with priority = highest. I have 7 columns in my table ; 1 column displays 1 attribute.

I'm succeeding to display 4 of my 7 columns. The 3 last columns are empty, even if the information is well described in my ticket. When I try to call the attribute value of my current ticket outside of my lookup issue loop, it's working. When I call it inside my lookup issue loop, it's not working.

Status of my audit log is "success".

 

 

Here is the code of my "Send mail" action:

<table style="border-collapse: collapse" table-layout="fixed" width="100%">
<tr>
<th style="border: 1px solid #000000; background-color : #CDCACA" valign="middle" halign="center">Clé</th>
<th style="border: 1px solid #000000; background-color: #CDCACA" valign="middle" halign="center">Résumé</th>
<th style="border: 1px solid #000000; background-color: #CDCACA" valign="middle" halign="center">Statut</th>
<th style="border: 1px solid #000000; background-color: #CDCACA" valign="middle" halign="center">Responsable</th>
<th style="border: 1px solid #000000; background-color: #CDCACA" valign="middle" halign="center">PIC</th>
<th style="border: 1px solid #000000; background-color: #CDCACA" valign="middle" halign="center">Priority</th>
<th style="border: 1px solid #000000; background-color: #CDCACA" valign="middle" halign="center">Last comment</th>
</tr>

{{#lookupIssues}}
<tr><td style="border: 1px solid #000000" valign="middle" align="center"><a href="{{toUrl}}">{{key}}</a></td>
<td style="border: 1px solid #000000" valign="middle">{{summary}}</td>
<td style="border: 1px solid #000000" valign="middle">{{status.name}}</td>
<td style="border: 1px solid #000000" valign="middle" align="center">{{assignee.displayName}}</td>
<td style="border: 1px solid #000000" valign="middle" align="center">{{customfield_11600}}</td>
<td style="border: 1px solid #000000" valign="middle" align="center">{{customfield_11601}}</td>
<td style="border: 1px solid #000000" valign="middle" align="center">{{comments.getFromEnd(0).body}}</td>
</tr>
{{/}}
</table>

 

Here is the result by mail:

 

 

Could it be a problem from administration right?

How could I display my values?

 

Thank you,

Bill Sheboy

Hi @Garn -- Welcome to the Atlassian Community!

For Jira Server / Data Center, the lookup issues action only supports some fields at this time.  Here is the suggestion to add more, which you may vote for / watch to see progress: https://jira.atlassian.com/browse/JIRAAUTOSERVER-877

When the lookup issues action was added for Jira Cloud, it also supported a limited number of fields.  About a year later, all of the remaining ones were added.  Perhaps that will also happen for the other versions.

 

Until then...a couple of work-arounds are:

1. Use a branch on JQL with the bulk-handling option, as that will provide the {{issues}} smart value, and allow handling issues the same as a lookup.  Please look here to learn more about that feature: https://confluence.atlassian.com/automation/run-a-rule-against-issues-in-bulk-993924653.html
2. Use a Send Web Request action to call the REST API function to search by JQL.  Then the {{webResponse}} could be used to iterate over the issues.

 

Kind regards,
Bill