Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to retrieve the latest comment in jira using JQL?

Lakshmi Prasanna
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!
April 8, 2020

Hi,

I have a requirement that i have to retrieve always the latest comment from JIRA tickets which i am querying using JQL

sample query which i am using right now is as follows---

project = ABC AND issuetype = bug OR project = "project1 " AND
issuetype = Bug AND component = "component_1"
OR labels in (cloud_bug) AND labels in (data_united)

Kindly Help us on this and provide some tips/hints in getting the latest comment using JQL.

Regards,

Lakshmi

3 answers

0 votes
Jerzy Wartałowicz
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!
August 24, 2021
0 votes
John Funk
Community Champion
April 9, 2020

Hi @Lakshmi Prasanna  - Welcome to the Atlassian Community!

You might find this previous post helpful, also:

https://community.atlassian.com/t5/Jira-Software-questions/JQL-Query-to-Display-Last-Comment/qaq-p/999310

Lakshmi Prasanna
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!
April 9, 2020

thank you

Like John Funk likes this
John Funk
Community Champion
June 8, 2022

@Lakshmi Prasanna  - Did this answer your question?

0 votes
Jack Nolddor _Sweet Bananas_
Atlassian Partner
April 9, 2020

Currently is it not possible to retrieve the lastComment field using JQL, you must go for a third-party app instead.

See Simple Last Comment for Jira which is currently FREE

 

Regards

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events