Extracting Comments into a spreadsheet

[Ashley Roberts]

We are using Jira 8.20 and we have a request to extract comments from tickets that are past their due dates. When we do an extract all fields, there is a column for comments, but it is blank.

The system does not have an add-on that we can use (as it is very expensive with the number of users we have).

Please can someone help in getting the comments exported?

The filter that we use is the following:

project = PROJECTID AND resolution is EMPTY AND duedate <= startOfDay(7d)

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Ashley Roberts

as already suggested, you should be able to include comments using the All Fields option. The downside is - if I remember correctly! - that this will create one column per comment, which might not quite be what you are after.

As an alternative, there's a number of apps available on the Atlassian Marketplace that provide better comment-exporting capabilities. 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 all comments (along with many other comment-related columns).

With the all comments column, you can easily view, sort, and filter by the latest comment directly in JXL, and get all comments into an Excel/Sheets export in just one click:

I should add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

As noted before, there'll be other Marketplace apps that can help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever.

Any questions just let me know,

Best,

Hannes

[Mohamed Benziane]

Hi,

you can try to export your issues using the csv export option (all fields).