How may I show comments from a issue in a filter?

[Mariano Losada]

Hello, I have create a filter with key columns for report and the "comment" column doesn't show anything. Of course the issues displayed have some comments . I would like to show in my filter those comments or at least dthe last one. Is it possible?

[Duc Thang TRAN · Accepted solution]

Hello @Mariano Losada 

Without a custom field or plugin, by default, you can't display a column with comments on a ticket via a filter.
In my instance, I use a custom multiline text field (last comment)  that shows the last comment. I also have a script that updates the value of this field whenever a comment is added to a ticket.

[Mariano Losada]

Hello and thank you. I think you're right, there are not other way to get the last comment. I hope some day Atlassian develop something for this. 

[Hannes Obweger - JXL for Jira]

Hi @Mariano Losada

if you're open to solutions from the Atlassian Marketplace, this would be easy to do using 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 long list of so-called smart columns that aren’t natively available, including the last comment (along with many other comment-related columns).

This is how it looks in action:

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

Any questions just let me know,

Best,

Hannes