Add more detail to Jira issue history reports

The default template set includes specialized versions of the issue-navigator.xlsx template to export the comments, worklogs, Tempo Timesheets worklogs, change history and issue links (commonly known as issue metadata) along with the field values. These specialized templates support both the selected fields and all fields scenarios, and append the metadata in the right.

For a well-structured spreadsheet, the metadata values are exported to separate columns (comment author, date and text to separate columns, or issue links grouped by link type and direction to separate columns) and to multiple rows (when an issue has multiple comments e.g.).

Next steps

Export samples

Jira issues with comments

Using the issue-navigator-with-comments.xlsx template, the Jira issue comments are exported to 3 separate Excel columns (comment author, submission time and text).

jira-issues-selected-fields-with-comments.xlsx

Jira Service Management tickets without internal comments

Use the intuitively named sdExportPublicCommentsOnly configuration variable in field-helper-tool.groovy to exclude internal comments from your Excel exports. It is perfectly possible to have two separate export options, one with and another without internal comments.

jira-service-management-tickets-without-internal-comments.xlsx

Jira issues with selected fields and worklogs

Use the issue-navigator-with-worklogs.xlsx template to export Jira worklogs to 4 separate Excel columns (time spent, author, submission time and comment text).

jira-issues-selected-fields-with-worklogs.xlsx

Jira issues with selected fields and repeating worklogs

issue-navigator-with-repeating-worklogs.xlsx is the repeating fields variant of the template in the previous example. It is a better fit for use cases that require searching, filtering and reporting on Jira worklogs.

jira-issues-selected-fields-with-repeating-worklogs.xlsx

Jira issues with selected fields and Tempo Timesheets worklogs

issue-navigator-with-tempo-worklogs.xlsx is the Tempo Timesheets-optimized version of the previous Excel template. It integrates with the Tempo Timesheets time tracking app and also exports the account and activity associated for each worklog.

jira-issues-selected-fields-with-tempo-timesheets-worklogs.xlsx

Jira issues with selected fields and repeating Tempo Timesheets worklogs

issue-navigator-with-repeating-tempo-worklogs.xlsx is the repeating fields variant of the template in the previous example. It is a better fit for use cases that require searching, filtering and reporting on Tempo Timesheets worklogs.

jira-issues-selected-fields-with-repeating-tempo-timesheets-worklogs.xlsx

Jira issues with selected fields and change history

Auditing requires you to export all fields with their complete change history to Excel. Using the issue-navigator-with-history.xlsx template, the changes made on the corresponding issue are exported to 5 separate columns (author, change time, changed field, old- and new value).

jira-issues-selected-fields-with-change-history.xlsx

Jira issues with selected fields and repeating change history

issue-navigator-with-repeating-change-history.xlsx is the repeating fields variant of the template in the previous example. It is a better fit for the use cases that require searching, filtering and reporting on field value changes.

jira-issues-selected-fields-with-repeating-change-history.xlsx

The issue-navigator-with-issue-links.xlsx template exports issue links grouped by link types and direction (inward vs. outward) to separate columns. It helps you to discover the dependencies (between use cases and implementation tasks or requirements and other requirements) or measure the test coverage (between features and test cases), for example. It also helps you find Jira issues with or without links and export them to Excel.

jira-issues-with-issue-links.xlsx