Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

It is crucial to include service-level agreements (SLAs) and operational-level agreements (OLAs) data

...

in a full and consistent report. SQL Connector for Jira allows exporting any Time To SLA app data into SQL for further analytics and building dashboards.

Info

Time To SLA fields are located in a separate tab

...

.

Image Added

Info

The following fields are available for export ⬇️

Fields Names and IDs

Indicator (INDICATOR)

Last Status ID (LAST_STATUS_ID)

Notified (NOTIFIED)

Paused (PAUSED)

Expected Target Date (EXPECTED_TARGET_DATE)

Issue ID (TTS_ISSUE_ID)

Last Status Name (LAST_STATUS_NAME)

Origin Status ID (ORIGIN_STATUS_ID)

Pause Duration (PAUSED_DURATION)

Working Duration (WORKING_DURATION)

Issue Key (TTS_ISSUE_KEY)

Last Status Date (LAST_STATUS_DATE)

Origin Status Name (ORIGIN_STATUS_NAME)

Target Status ID (TARGET_STATUS_ID)

Created (CREATED)

Finished (FINISHED)

Last Updated Date (LAST_UPDATED_DATE)

Origin Date (ORIGIN_DATE)

Actual Target Date (ACTUAL_TARGET_DATE)

Updated (UPDATED)