Latest Comments in JIRA Filter

Backiyaraj Mani
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 26, 2023

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.

2 answers

1 vote
Dan Tombs
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 26, 2023

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

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
August 1, 2023

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,



Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events