How can I add the most recent comment from activity to my issues list view?

[ossarchitect]

The list view has a field "number of comments", but I would like to see the most recent comment as text field in the issues list. This would be helpful because it would in many cases not require to open the actual issue to see whether an action is necessary. There are a number of fields such as "comments" but they do not seem to do anything (stay blank). Am I missing something?

[Hannes Obweger - JXL for Jira]

Hi @ossarchitect

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, you may want to have a look at 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, many other comment-related smart columns). 

This is how it looks in action:

As you can see above, you can easily sort and filter by your issues' comments, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This all just works - there's no scripting or automation whatsoever required.

Any questions just let me know,

Best,

Hannes

[Tuncay Senturk]

Hi @ossarchitect 

There is no bundled and ready solution for that. However you can achieve that with either Automation or using an app.

Automation:

- First create a custom field (text field), "Most Recent Comment"

- then create an Automation rule, trigger: Issue commented, action: Edit Issue, field: Most Recent Comment, value: {{comment.body}}

- you can also add comment's author and date to this field, that's up to you.

App solutions:

- you can use Enhancer Plugin for Jira or ScriptRunner for Jira in which you can easily define this custom field