Latest Comments in JIRA Filter

[Backiyaraj Mani]

Wants to get the Latest comments in JIRA filter report. Unable to get any value from comments fields.

1. Want to extract latest or last 3 comments from JIRA item. 

2. Also looking extract Linked items. Like Story, Task or Sub Task. Linked Item giving commits etc. We need only Linked items.

Appreciate the help in pulling this information.

[Dan Tombs]

Hi @Backiyaraj Mani

you will probably need to look to additional marketplace apps when it comes to gain that data within JQL. 

you could get the last comment from automation for Jira but you will need an additional custom field to store the data in so you can see it in JQL. 

you could try the JQLextensions for Jira app

[Hannes Obweger - JXL for Jira]

Hi @Backiyaraj Mani

welcome to the community!

If I may provide a concrete Marketplace app recommendation, this would be trivial 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 number of so-called smart columns that aren’t natively available, including the latest 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 latest comment, and also use it across JXL's many 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