Getting Last comment from #lookupIssues using JIRA server

Question

This is similar to this issue to this. I am able to use the #lookupIssue and retrieve elements from multiple issues, but I am not able to retrieve the last comment of each issue. Is this because I am not in the cloud version of JIRA? Below is what I have, where comment doesn't display:

{{#lookupIssues}} 
{{#if(equals(status.name, "To Do"))}}
Ticket ID: {{key}}
Updated: {{updated.mediumDate}} 
Summary: {{summary}} 
Reporter: {{reporter.displayName}} 
Assignee: {{assignee.displayName}}
Last Comment: {{comments.last.body}}  
{{/}}
{{/}}

*

Ticket ID: Key-733
Updated: Nov 12, 2024
Summary: Create account
Reporter: Jane Doe
Assignee: John Doe
Last Comment:
* Ticket ID: Key-544
Updated: Nov 27, 2024
Summary: Create Database
Reporter: John Doe
Assignee: Jane Doe
Last Comment:

Also recieved suggestions on workarounds:

* use the bulk-handling feature of the Scheduled Trigger or branches, with the plural {{issues}} smart value
* use the Send Web Request action to call the REST API to perform an issue search with JQL, and access the fields from the web response.

But any suggestions on what's the easiest considering the use case that I have?

Bill Sheboy · Answer

Hi @henry_lin -- Welcome to the Atlassian Community!

For Jira Data Center, the Lookup Issues action does not yet support the Comments field:

https://confluence.atlassian.com/automation/jira-smart-values-issues-993924860.html#Jirasmartvaluesissues-lookupissueslookupIssues

https://jira.atlassian.com/browse/JIRAAUTOSERVER-877

There are two possible workarounds to replace the Lookup Issues action usage, depending upon the situation:

* use the bulk-handling feature of the Scheduled Trigger or Branches with the plural {{issues}} smart value: https://confluence.atlassian.com/automation/run-a-rule-against-issues-in-bulk-993924653.html
* call the REST API endpoint for issue search with JQL, using the Send Web Request action, and use the web response to access the fields

You could use the first one for your case.

The second is needed when your rule is already using branching or when you need the issue data to edit another issue.  For example, to sum such as Story Points into a parent Epic.

Kind regards,
Bill

henry_lin · Answer

Hi @Trudy P Claspill

Appreciate the quick reply! Implemented the {{comments.size}} and it returned a blank, but when looking at the specific ticket in JIRA, it does have comments, so I'm not sure why it's not returning me anything. For some reason, this only happens with #lookupIssue. If I remove this, I can retrieve the last comment for a single issue.

Trudy P Claspill · Answer

Hello @henry_lin

Welcome to the Atlassian community.

According to the documentation for A4J in the latest Jira DC version, that should work.

https://confluence.atlassian.com/automation/jira-smart-values-issues-993924860.html#

As an experiment can you add a line to print the number of comments associated with each issue? i.e.

Comment count: {{comments.size}}
Last Comment: {{comments.last.body}}  
{{/}}
{{/}}