How can I search for issues that were commented in the last 4 hours

[Samuel Bar]

I would like to search for all the issues that have been commented on in the last 4 hours. I have tried Jira AI, and the suggested result is to use this - 'commented > "-4h", but at the same time, there is an error message saying that "commented" does not exist. I would appreciate it if you could suggest a solution for my JQL and, if possible, an explanation of the AI response.

[Hannes Obweger - JXL for Jira]

Hi @Samuel Bar

I don't think that this is possible natively, however I've seen people use Jira Automation to detect the date of the last comment and write it into a custom field. You can then filter based on this custom field.

Alternatively, if you're open to solutions from the Atlassian Marketplace, there are other options available. I'll provide more information below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

... and just to expand on the last point: If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues 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 time since last comment, along with many other comment-related columns.

This is how it looks in action:

As you can see above, you can easily sort and filter by your comment columns; you can also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know!

[aaron.phillips]

I believe it is not possible to search for the last comment using the native JQL library, however you can sort by `updated > -4h` which will give you all updated issues within that time, however you are likely to get a lot of false returns for issues value updates etc.