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 🤠☀️

[Tuncay Senturk _Snapbytes_]

Hi @Sathish Kumar 

Native JQL can’t filter by comment author or comment date, comments aren’t indexed as JQL fields. Tricks like updated >= -24h catch all issue changes, not just comments.

For a dashboard widget (Filter Results gadget + saved filter), you need extended JQL. There are some JQL apps on the market, you can use one of them which comes with a valid comment JQL for your needs

I’m on the team behind SnapJQL, which adds comment search:

sj_commentAuthor IN membersOf("My Team") AND sj_commentCreated >= -24h

Save as a filter → add to dashboard. Happy to help tune it for your setup.

[Natalia_Kovalchuk_SaaSJet_]

Hi @Sathish Kumar !

Unfortunately, using Jira JQL alone, you won't be able to filter comment updates from a specific team or users during a specific time period. While JQL can help find recently updated tickets, it doesn't give detailed reporting on comment history.

In this situation, I recommend trying Issue History for Jira (Work Item History) app by SaaSJet.

Using the app, you can filter Jira tickets by:

• Spaces 
• Updaters
• Time periods (for example, the last day)
• Field - Comment

For example:

You can save the report configuration in the app and reuse it whenever necessary.

One of the main benefits of the Issue History for Jira (Work Item History) app is its ability to track comment additions, edits, and deletions (when comment tracking functionality is enabled). 

If you want to automate reporting, the app also has an API that lets you retrieve report data automatically for use in external tools such as Google Sheets, Power BI, Looker Studio, or other analytics platforms.

This makes it simple to monitor team comment activity, build dashboards, and create custom reports based on Jira comment history.

[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