I need Issues comments history through JQL or in bulk

[shiva kumar Gosul]

I need Issues comments history through JQL or in bulk. 

[Natalia_Kovalchuk_SaaSJet_]

Hi @shiva kumar Gosul !

Unfortunately, JQL in Jira does not support searching or exporting the comment history of multiple issues directly. 

I recommend trying the Issue History for Jira app from my team. It can help you to view, filter, and export all comments (along with other issue changes) in bulk in Excel or CSV formats.

To get the comment history and export it, after the app installation, you need to perform the following actions:

1. Use the filter by project, assignee, sprint, etc.
2. Choose "Updated by Any user" or select the specific users needed.
3. Set the required date range.
4. In the Columns menu, choose Comment. 

As a result, you will get such a report: 

You can export such a report easily.

Here you can find more detailed info related to comment tracking and export with the help of Issue History for Jira app: https://help.saasjet.com/ih_cloud/tracking-comment-changes-in-Jira

[shiva kumar Gosul]

Thank you so much for all your responses, I did not know that Issues History for for App exist. I am using enterprise Jira Instances not cloud version. 

@Marc - Devoteam I agree with your solution however I am looking entire project issues comment history last from 1 year. To understand what are the common issues, RCA and other solutions implemented through the comments. Like Project ABC, 1000 Issues and their comments history, I am able to fetch last comment and only the latest comment but not the Comment's history of all issues. 

[Marc - Devoteam]

Hi @shiva kumar Gosul 

Then you can look at the API or 3rd party marketplace solutions

[Rahul_RVS]

Hi @shiva kumar Gosul 

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

However if you need detailed reporting to track comment 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.

Issue History Reports

[Marc - Devoteam]

Hi @shiva kumar Gosul 

Issue history can be view in the history section of an issue, but you can only see the comment was edited.

An alternative option, to get comment updates is Jira automation. Look at condition “Issue comment edited” and you can try some smart values like {{comment.body}} and {{comment.latest.body}} and send those to the email.

There is also an open feature request for this, see; JRACLOUD-80996 

Or check for 3rd party options on the Atlassian Marketplace