JQL Reports and export

Data Center This page documents Time in status, Timer, Stopwatch and Calendar fields for Jira Data Center and Server. On Jira Cloud? See Time in Status (Forge) for Jira Cloud.
You can export fields from JQL search to excel, xml or Confluence.
The field may have different display formats in the interface and when exporting.

The Custom Field displays the Time spent in In Progress Status in JQL field.

jql-exmaple-field screenshot

But upon exporting as CSV , it shows an error (JSON format).

jql-example-field-json screenshot

For fix: Please set the format you need in the export section in the field settings. It is located at the bottom of the page.

What you are seeing is the field value as it really is - a computed object whose duration lives in the time property, in seconds. If you are exporting for a BI tool rather than for a human, keep the seconds instead of formatting them: see Field value format and export for BI.

JiBrok time in status Time in status | SLA | Timer | Stopwatch
Migration
Release notes
Tutorials
Settings
Troubleshooting
Work calendars
Time in status
Timers and Stopwatches
Stopwatch
Timer
Additional functions
Issue panels
Reports
Field Helpers
Other fields
API
Reference information