I need to display the most recent comment in a JQL/ dashboard in Server /DataCenter

[StephanieC]

I need to display the most recent comment in a JQL/ dashboard in Server /DataCenter

All we can find are solutions for Cloud !!

We also have ScriptRunner & JMCF if that is helpful. 

[Nic Brough -Adaptavist- · Accepted solution]

I usually do this as a scripted field, but you could do it by writing to standard custom field in a listener.

The core code you need for Scriptrunner is at https://library.adaptavist.com/entity/show-last-comment-issue

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @StephanieC

if you're open to other apps from the Atlassian Marketplace, this would also work out of the box in the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called "smart columns" that aren’t natively available, including the last comment (along with many other comment-related data).

This is how it looks in action:

You can also use the last comment across JXL's advanced features - such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - and "inline-add" new comments either to individual issues or in bulk, via copy/paste. 

This all "just works", so there's no scripting or automation whatsoever required.

Any questions just let me know,

Best,

Hannes

[Andrew Laden · Accepted solution]

Another option would to be to use automation to copy the most recent comment to a custom field when a comment is added to an issue. There is a smart value for the last comment.

Similar idea to the scriptrunner listener, but you can do it with automation for jira and not have to worry about scriptrunner coding.

[Nic Brough -Adaptavist-]

Bear in mind that that requires yet another app to be bought and installed.

[Andrew Laden]

Automation for jira comes with DataCenter now.

[Manoj Gangwar · Accepted solution]

Hi @StephanieC , 

You may refer to the below vendor document. 

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/comments