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 |
...
. |
| 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) |