JQL to find comments updated by

[Sathish Kumar]

I'm trying to build a widget to find all tickets that were commented by team in last 24 hours. 

tried some community answers nothing works. 

[Pablo Vergara]

Hi @Sathish Kumar 

Unfortunately, this is not possible using Jira Cloud native's JQL functions.

As you can see in https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#updatedBy-- , the updatedBy() JQL function only supports a username as a parameter.

If you're willing to use a third-party Jira Cloud plugin, I could suggest an alternative solution.

Regards,

- Pablo

[Arkadiusz Wroblewski]

Hello @Sathish Kumar 

@Pablo Vergara is right, JQL doesn't actually let you filter by comment author or date.😔

You can get close using updatedBy(), but that catches any update to the ticket, not just comments🤔.

If you need it to be exact, your options are pulling the data via the REST API, using an automation rule to stamp a custom field when someone comments, or looking into a Marketplace app that adds extra JQL functions.

Best,

Arkadiusz 🤠☀️

[Rahul_RVS]

Hi  @Sathish Kumar 

You can use Jira Rest Api's to pull this information and build your own custom solution.

However if you need detailed reporting to track changes for multiple issues, you may want to have a look at a mktplace app for the same.

We have built an app to extract changelog data in a simple and easy to use interface. The data can be exported to a CSV file as well.

It provides complete details of who added comments, what was changed and when. 

Issue History Reports

Do give it a try.

Disclaimer : I am part of the app dev team

[ben_snyder]

Hi @Sathish Kumar,

To add on, finding issues based on specific comment activity can be a bit tricky in native Jira, as standard JQL doesn't provide a direct way to search for the author of a comment or the specific date a comment was updated. The closest native approach is using the `updated` field (e.g., `updated > -1d`), but this tracks any change to the issue, not just comments. You can also use the `comment ~ "text"` operator to search for keywords within comments, but it won't specifically isolate who made the update or when that specific comment was edited. For many teams, this means manually checking issue history or relying on notifications to track these specific interactions.

If you're looking for more precision, JQL Search Extensions for Jira is designed to fill these exact gaps in native search. It introduces several extended keywords that allow you to pinpoint comment activity directly in your JQL queries. For your use case, you can use `commentedByUser` to find issues where a specific person has participated in the conversation. Additionally, the app provides keywords like `commentUpdatedOnDate` and `commentLastUpdatedOnDate`, which let you filter issues based on when a comment was actually modified. This makes it much easier to build queues or reports that focus specifically on recent discussions rather than general issue updates.

To take this a step further, Dashboard Hub for Jira can help you visualize this data. It includes a "Jira Custom Charts" gadget that allows you to plug in these extended JQL queries to create custom reports, such as pie charts or bar graphs. This is particularly useful if you want to build a dashboard that tracks comment activity across your team or monitors response times based on when comments were last updated, providing a clear visual overview of your team's engagement directly within Jira.

Thanks, Ben Snyder

JQL Search Extensions Marketplace

Dashboard Hub for Jira Marketplace