JQL reports and export


Overview

Timer field values can be exported from Jira using the Issue Navigator’s built-in export functionality. This works for both field types of the app: Timer and Calendar Select.


Displaying fields in the Issue Navigator

  1. Go to Jira and run a JQL query
  2. Switch to List view in the Issue Navigator
  3. Click Columns to customize which columns are displayed
  4. Search for and add your Timer field(s) to the column list

The field’s displayValue (formatted time string) appears in the column.


Exporting to Excel / CSV

  1. Run your JQL query in the Issue Navigator
  2. Click the Export button (top-right of results)
  3. Choose your export format:
    • Export Excel CSV (all fields) - exports all visible fields
    • Export Excel CSV (current fields) - exports only the currently displayed columns
  4. The downloaded file includes the field’s display value

What is exported

The exported value is the display value of the field - the formatted time string (e.g., “2h 30m”, “1d 4h 15m”). This is the same value shown in the Issue Navigator column.


Reading values through the Jira REST API

To load field values into an external reporting system, read them with the Jira Cloud REST API instead of exporting files. The app writes each field value to the issue as a JSON object, so a search returns the same properties that JQL searches use - not only the display string.

Properties of the field value

Each property has a JQL alias (used in "Field name.Alias"). In the REST response the property name is the same alias starting with a lowercase letter - for example SecondsValue → secondsValue.

Field type Properties (JQL aliases)
Timer DisplayValue, HoursValue, MinutesValue, SecondsValue, TimeInHoursValue, TimeInMinutesValue, StateValue, GoalTimeSeconds, LeftTimeSeconds, PauseTimeSeconds, DateNextUpdate, DateLastCalculated, FirstStartDate, LastStartDate, StopDate, FailDate, LastPauseDate, RestartCount
Calendar Select CalendarId, CalendarName

What each property means and how to search by it: Timer JQL, Calendar Select field.

Find the field ID

The REST API addresses custom fields by ID. List the fields and find yours by name:

GET /rest/api/3/field

The entry for your field carries "id": "customfield_NNNNN".

Select issues by JQL and read values page by page

GET /rest/api/3/search/jql?jql=project%20%3D%20SUPPORT&fields=customfield_NNNNN&maxResults=100

The response contains up to maxResults issues and, when more remain, a nextPageToken. Request the next page with the same query plus that token, and repeat until the response has no nextPageToken:

GET /rest/api/3/search/jql?jql=project%20%3D%20SUPPORT&fields=customfield_NNNNN&maxResults=100&nextPageToken=<token from the previous response>

Each issue in issues carries the field value as an object:

{
  "key": "SUPPORT-42",
  "fields": {
    "customfield_NNNNN": {
      "displayValue": "2h 30m",
      "secondsValue": 9000,
      "timeInHoursValue": 2.5,
      "stateValue": "Active",
      "dateNextUpdate": "..."
    }
  }
}

The object shows a subset of properties; the full set for your field type is in the table above.

Filter by a property in the same request

The jql parameter accepts the property aliases, so the filtering happens in Jira, not in your report:

project = SUPPORT AND "Timer.SecondsValue" > 3600

Replace Timer with the name of your field.

The value can lag behind the issue panel

The app updates the stored value in steps; dateNextUpdate tells when the next update is due. Between updates the value returned by REST (and searched by JQL) can be behind the live time shown in the panel on the issue. For reports, take this lag into account or schedule the export after the update time.


Using JQL for reports

Combine JQL searches with field exports to create reports:

Example: Issues exceeding SLA

project = "SUPPORT" AND "SLA Timer.StateValue" = "Failed"

Export the results with Timer fields visible to see which issues failed and by how much.


Tips

  • Sort before export: use ORDER BY in your JQL to pre-sort the exported data.
  • Multiple fields: you can add multiple Timer fields to the column list and export them all at once.
  • Spreadsheet analysis: after exporting to CSV/Excel, use pivot tables or charts to analyze time spent, time left and SLA results across projects, priorities, or time periods.
  • Scheduled exports: combine JQL saved filters with Jira automation or external tools to schedule periodic exports for reporting.