Is there a way to find out the comments that were made in the last 24hrs/48hrs using jql

[Mahanth Prudhvi P]

Is there a way to find out the comments that were made in the last 24hrs/48hrs using jql in Jira cloud. I think it is possible in server using issuefunction() in jql but it is not working in Cloud.

Regards,

Mahanth Prudhvi P

[Yuliia_Borivets__SaaSJet_]

Hi @Mahanth Prudhvi P 

As JQL doesn't work for this case, you might explore alternative solutions:

1) Activity Stream gadget (built-in on Jira dashboard). It allows filtering by comments and dates (it's only possible to choose dates, not hours)

2) Issue History for Jira (app from my team). You can filter by dates and comments (or any other field). Export and other additional filters available (projects, updated by, etc.)

[Rahul_RVS]

Hi @Mahanth Prudhvi P 

There are few options to get this information.

Use Activity Stream gadget / Use Jira Rest API's and build your own custom solution or explore mktplace apps for detailed and flexible reports

If you are open to try a mktplace app, take a look at

Issue History Reports 

The app shows the complete history of changes for your filtered issues and the issue comments as well

Disclaimer - I am part of the app team

[Hannes Obweger - JXL for Jira]

Hi @Mahanth Prudhvi P

JQL always and only allows querying issues - so you won't ever be able to query comments using JQL, you'll always only be able to query issues with certain comments on them.

This being said, comment-based querying is somewhat limited in native JQL, too. However if you're open to solutions from the Atlassian Marketplace, you should get pretty close to what you're looking for.

E.g., you may want to have a look at the app that my team and I are 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 long list of so-called smart columns that aren’t natively available, including the last comment, the date of last comment, and many, many more.

This is how it looks in action:

As you can see above, you can easily sort and filter by your comment fields, and 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,

Best,

Hannes

[sanam malleswari]

Hi @Mahanth Prudhvi P

To find comments made in the last 24 or 48 hours using JQL in Jira, you can use the issueFunction provided by the ScriptRunner plugin. Unfortunately, Jira's native JQL does not support this functionality directly.

issueFunction in commented("after -24h")

[Vishal Biyani]

This may not be feasible using JQL.

issueFunction is provided by ScriptRunner. Possibly you have Script runner in Server