Issue History Export for Jira: documentation
Options
- JQL or saved filter. Any JQL Jira accepts. Saved filters you own are listed.
- Date range. Applies to change timestamps, in the timezone you pick. The end date is inclusive. Transitions and Assignee history keep every period that overlaps the range. Time in status always covers creation to export time.
- Fields. Status only, all fields, or a comma separated list of field names or ids. Status and assignee history are always read so the Transitions, Time in status and Assignee history sheets stay correct.
- Timezone. Defaults to your Jira profile timezone. Timestamps are written as local time in that zone.
- Cycle time. Type two status names. Cycle time is the time from the first entry into the first status to the next entry into the second. It is blank when an issue never reached both.
Sheets
- Changes: issue key, summary, type, field, from, to, author, timestamp.
- Transitions: issue key, from status, to status, entered, left, duration (hours), changed by, current. The first row of an issue shows "(created)" as the from status.
- Time in status: one column per status with total hours over every visit, total hours, and cycle time.
- Assignee history: issue key, assignee, from, to, duration (hours), current.
- Run info: JQL, date range, timezone, generated by, row counts and notes.
Large exports
The app searches 100 issues per call and reads changelogs 100 issues per call using Jira's bulk changelog endpoint, falling back to one call per issue if that endpoint is unavailable. Each Excel sheet holds up to 1,048,575 data rows. If a call fails, an error is shown with a Resume button that continues from the last finished batch. Stop writes a workbook of what was read so far.
Permissions
Scopes: read:jira-work and read:jira-user. The app never writes to Jira. It runs as the signed-in user, so project permissions and issue security apply and you only get rows for issues you can see.
Not in version 1
Business hours calendars, scheduled exports, comments and Jira Data Center.