Is it possible to create a quick filter or a view for tickets with recent comments?

Question

Problem statement: Our team does not effectively track their notifications for whenever they are tagged in comments. I am looking for an easy view for engineers and product teams to see tickets where a comment was added in the past 24 hours.

Steps to resolve:

I tried searching for a query option for Comment Date, but that doesn't appear to exist.

mauricio.groth · Answer

Hi @Devon Holt

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your tickets that the last comment was between the start of the last day(yesterday) and the start of the day today.

commentLastUpdatedOnDate >= startOfDay(-1) and commentLastUpdatedOnDate <= startOfDay()

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!
Best regards,
Maurício

Hannes Obweger - JXL for Jira · Answer

Hi @Devon Holt

if you're open to solutions from the Atlassian Marketplace, I believe your use case would be easy to solve with the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view 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 date of last comment (along with many other comment-related columns).

This is how it looks in action:

You can also use the column in JXL's advanced features, such as support for issue hierarchies, issue grouping, sum-ups, or conditional formatting.

Once you've narrowed down your list of issues, you can work on these issue directly in JXL, trigger various operations in Jira, or export your issues in just one click.

Hope this helps,

Best,

Hannes

Bill Sheboy · Answer

Hi @Devon Holt -- Welcome to the Atlassian Community!

You are correct: there is no built-in way to search for the last commented date.  If you have one of the marketplace addons for JQL, those may help.

With out-of-the-box features, this JQL would get you close to the answer:

project = myProjectName AND comment ~ accountId AND updated >= -24h

Mentioning a user in a comment adds the text [~accountid:specificUserAccountId] and so you could search for part of that expression and check the updated date is within the last 24 hours.

Another work-around would be to use an automation rule and custom field to track the last date/time a comment was added to issues.  That custom field could then be searched with JQL.

Kind regards,
Bill