nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query for Last Comment

danielmaycock

I'd like to be able to have a query (or quick query) that shows the last comment for all my project's stories. Currently I have to open up each individual story & scroll down for this. Having a query that shows this, lets me know quickly if its been updated or not.

Accepted answers

Alex_dddmmh

Hi @danielmaycock welcome to the community!

Jira will not have a function that shows the last comment in JQL. But, I believe you can have similar results with this JQL

updated > startOfDay()

For the additional functions that work with date fields check out https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-endOfDayendOfDay--

Also, I found an interesting post that explains how to display the last comment on a custom field using automation for Jira (https://community.atlassian.com/t5/Marketplace-Apps-Integrations/How-to-display-Last-comment-in-Filter-JQL-and-any-Add-on/ba-p/1489153).

You might be able to store the last comment's date in a date custom field by switching

{{issue.comments.last.body}}

{{issue.comments.last.created}}

then create a filter that sort by that date custom field

I hope it helps. If this answer helps solve the problem, please come back and mark this answer as solved to help other community members with the same challenge. If not, you are welcome to share your solution as well.

Cheers,

Alex

Daniel Turczanski - JQL Search Extensions

You may be interested in our commentLastUpdatedOnDate JQL alias.

You can find issues that were recently commented on and order them by the comment date:

commentLastUpdatedOnDate < -2d order by commentLastUpdatedOnDate desc

It's part of JQL Search Extensions.

All comments

Alex_dddmmh

Hi @danielmaycock welcome to the community!

Jira will not have a function that shows the last comment in JQL. But, I believe you can have similar results with this JQL

updated > startOfDay()

You might be able to store the last comment's date in a date custom field by switching

{{issue.comments.last.body}}

{{issue.comments.last.created}}

then create a filter that sort by that date custom field

Cheers,

Alex

danielmaycock

Hi Alex,

Thanks very much for your quick reply.

In your first suggestion:

updated > startOfDay()

Does it require a numeric in between ()? What does the query mean? Is it anything that has been updated after "startOfDay"?

danielmaycock

Hi Alex, just wondering if you have a thought on this? I can also put it out to the community?

Thanks,

Daniel

Alex_dddmmh

Hi @danielmaycock

The function StartOfDay() performs searches based on the start of the current day. It lists issues that have been updated after the beginning of the day.

There are many other time-related functions in JQL. You can have the complete specification of all JQL out-of-the-box Jira functions at this link Advanced search reference - JQL functions.

Cheers,

Alex

Daniel Turczanski - JQL Search Extensions

You may be interested in our commentLastUpdatedOnDate JQL alias.

You can find issues that were recently commented on and order them by the comment date:

commentLastUpdatedOnDate < -2d order by commentLastUpdatedOnDate desc

It's part of JQL Search Extensions.

Balaji

Use this below, but I think you need ScriptRunner installed:

issueFunction in lastComment("by <add user name here>") ORDER BY updated DESC

Eric Lyke_ryrewl

Hi Daniel,

This doesn't work on Jira Cloud. Any easy ways to get the same last comment using JQL on Jira Cloud?

Thanks,

Eric

Myesha

Howdy from Texas! My name is Myesha and I am excited to answer this question! I am a Kanban Lead for 4 Kanban teams and had this exact same challenge. My organization does not allow me to use any plugins or ScriptRunner so I had to find a solution with out of the box Jira. I was able to solve it by creating a custom date field, setting up an automation and then creating a JQL query based on the new custom field.

Assignee Last Comment Automation Rule.png

Assignee Last Comment Automation Rule.png

To achieve the functionality of tracking when the last comment was made by an assignee on a JIRA ticket, you can follow these steps:

1. **Create a Custom Date Field:** Begin by creating a custom date field named something like "Assignee Last Comment Date." This field will store the date of the last comment made by the ticket assignee.

2. **Trigger

* Configure the automation to trigger whenever a new comment is added to an issue.

Rule is run when a new comment is added to an issue.png

3. **Add a smart values condition

* Add a condition to check if the `Assignee Name` equals the `Comment Author's Display Name`.

{{assignee.displayName}}
{{comment.author.displayName}}

Compare 2 values using smart values and regular expressions.png

4. **Edit Issue

* If the condition is true (meaning the assignee made the comment), update the "Assignee Last Comment Date" custom field with the current date.

5. **Create a JQL Query for Reporting:**

- Use a JQL query to identify tickets where the "Assignee Last Comment Date" is older than your team's agreed-upon update frequency (e.g., more than 1, 2, or 3 days). Here’s an example of such a query:

statusCategory = "In Progress" AND "Assignee Last Comment Date" <StartOfDay(-3)

This will show you all tickets in progress where the assignee has not commented in the last three days.

This setup will allow you to efficiently monitor and ensure that all tickets are updated as per team expectations without having to manually check each one.

NOTE!

Please note that while this automation rule will effectively track comments made by assignees from the moment it is set up, it does not retroactively apply to tickets with comments made before the rule was implemented. This means that any tickets that needed updates prior to the implementation will not be automatically flagged by this rule. For those, you might need to manually review or set up a temporary measure to ensure they meet the team's commenting expectations until they receive new comments under the new system. This automation is primarily beneficial on a go-forward basis, helping to maintain regular updates moving forward.

Hope this helps!

Nic Brough -Adaptavist-

Please, don't use AI to answer questions - this "solution" is not correct, it does not address the problem.

Myesha

Hi Nic Brough! Good day to you! Are you doing okay? I see you are saying that my solution is not correct and it does not address the problem. Can you explain why you feel like that? I am running this on multiple Jira projects and it is working perfectly. Also, I am not using AI to answer questions, I am using a solution that I designed myself after countless hours of searching and searching due to the fact that my organization does not allow me to use any plugins or add-ons or ScriptRunner. I had to come up with a solution using out-of-the-box Jira. I just want to help Scrum Masters and Kanban Leads like myself who are facing similar restrictions. I hope you have a really great day and I wish you the very best.

Nic Brough -Adaptavist-

Please read the original question again, and compare what they are looking for with the output you get from your "solution". They will not match.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

comment

jira-software

jira-software-cloud

jql

atl-gruland

query

story