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
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events