Document toolboxDocument toolbox

Time To SLA

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.

Time to SLA.jpg

The following fields are available for export

Fields Names and IDs

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)