How to Use SLA Data Stored in Database
This page is about Time to SLA for Jira Server users. |
The Time to SLA app provides various REST APIs to retrieve SLA data stored in the app. You may want to get that information from the database to use with business information tools. On this page you will learn the reasons behind limited data access to SLA data in a database, and how to interpret that limited information. |
Important Notes and Disclaimer
- Information stored in the database by the Time to SLA plugin is never meant to be used externally. We do not guarantee the integrity of the information you have collected by those instructions here. Use them at your own risk.
- Database tables store vital information for Jira, Time to SLA, and many other plugins. Manually working on it might cause irreversible damage or bad application performance due to corrupted table statistics etc.
- When possible, use REST services instead. If something is missing from REST services, please raise a ticket, and we will do our best to provide related services.
AO_C5D949_TTS_ISSUE_SLA : SLA Data on issues
This table stores intermediate information required to speed-up the calculation of updated SLA values on an issue. Each line represents an SLA instance on a single issue. |
Column | Type | Explanation | Reference |
---|---|---|---|
ID | Number | ID of this SLA instance. Note that this ID is subject to change at any time. | |
SLA_ID | Number | ID of the SLA definition this SLA instance belongs to. | AO_C5D949_TTS_SLA.ID |
ISSUE_ID | Number | ID of the issue this SLA instance belongs to. | jiraissue.id |
ORIGIN_DATE | Date | Exact instant this SLA instance started to count. | |
EXPECTED_TARGET_DATE | Date | Deadline for this SLA instance. | |
ACTUAL_TARGET_DATE | Date | Actual instant that this SLA has reached its target condition. | |
RESET_DATE | Date | Last reset instant for SLA. | |
INDICATOR * | String | Current state of SLA (EXCEED, STILL or SUCCESS). | |
PAUSED | Boolean | Whether or not SLA is paused. | |
FINISHED | Boolean | Whether or not SLA is completed. | |
WORKING_DURATION * | Integer | Elapsed time from the start of SLA in milliseconds. | |
PAUSED_DURATION * | Integer | Time spent on paused state (when SLA in progress) in milliseconds. | |
FORMATTED_WORKING_DURATION | String | Formatted working duration, filled only when SLA is completed. | |
FORMATTED_PAUSED_DURATION | String | Formatted paused duration, filled only when SLA is completed. |
* Limitation applies for information stored on those columns please see the following:
|
Here are some queries to differentiate different SLA states:
Met SLAs |
---|
"INDICATOR" = 'MET' |
Progress SLAs (Including paused ones) |
---|
|
Progress SLAs (Excluding paused ones) |
---|
( "INDICATOR" = 'STILL' AND "EXPECTED_TARGET_DATE" > now()) OR "PAUSED" is false |
Exceeded SLAs |
---|
( "INDICATOR" = 'EXCEED' OR ( "INDICATOR" = 'STILL' AND "EXPECTED_TARGET_DATE" < now())) AND "PAUSED" is false |
Completed SLAs |
---|
"FINISHED" is true |
SLA Indicator custom field displays paused SLAs as PROGRESS |