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.
Time To SLA fields are located in a separate tab.
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) |