Fetch Last comment on a task

[Niraj Kumar]

How to create a JQL to fetch the last comment statement made on a task, if we can get the commentors name and date-time that would be awesome.

[Marc -Devoteam- · Accepted solution]

Hi @Niraj Kumar 

You can look at this community article, how to achieve such a solution with a custom field and automation.

Display-Last-comment-in-Filter 

[Niraj Kumar]

Unfortunately, I don't have JIRA admin access to make these changes.

[Staffan Redelius · Accepted solution]

Hi @Niraj Kumar and welcome

You can use JQL to retreive work items and that will fetch all the work items that fit the criterias you define in the JQL. You can add a column showing the number of comments but there is no way to extract the last comment via JQL.

You could probably be able to extract the information via the REST API.

Could you elaborate a little on your case so we might ge a better understanding of what you want to achieve?

Best regards,
/Staffan

[Niraj Kumar]

Let's say someone commented "Review completed, Looks good, assigning to Tech Team" and it is the last comment on the task.

I need to fetch "Review completed, Looks good, assigning to Tech Team"  and on what date-time by whom it was commented.