See our new document.

Time to SLA app provides various REST APIs to retrieve SLA data stored in app. Sometimes customers want to obtain those information from database mostly to be used with business information tools. This article explains reasons behind limited data access to SLA data in database and how to interpret those limited information.

  • Information stored in database by 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 stores 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 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.

ColumnTypeExplanationReference
IDNumberID of this SLA instance. Note that this ID is subject to change at any time.
SLA_IDNumberID of the SLA definition this SLA instance belongs to.AO_C5D949_TTS_SLA.ID
ISSUE_IDNumberID of the issue this SLA instance belongs to.jiraissue.id
ORIGIN_DATEDateExact instant this SLA instance started to count.
EXPECTED_TARGET_DATEDateDeadline for this SLA instance.
ACTUAL_TARGET_DATEDateActual instant that this SLA has reached its target condition.
RESET_DATEDateLast reset instant for SLA
INDICATOR *StringCurrent state of SLA (EXCEED, STILL or SUCCESS).
PAUSEDBooleanWhether or not SLA is paused
WORKING_DURATION *IntegerElapsed time from the start of SLA in milliseconds.
PAUSED_DURATION *IntegerTime spent on paused state (when SLA in progress) in milliseconds
FORMATTED_WORKING_DURATIONStringFormatted working duration, filled only when SLA is completed
FORMATTED_PAUSED_DURATIONStringFormatted paused duration, filled only when SLA is completed


* Limitation applies for information stored on those columns please see following:


Here are some queries to differentiate different SLA states:


"INDICATOR" = 'MET'


("INDICATOR" = 'STILL' AND "EXPECTED_TARGET_DATE" > now()) OR "PAUSED" is true


("INDICATOR" = 'STILL' AND "EXPECTED_TARGET_DATE" > now()) OR "PAUSED" is false

(info) SLA Indicator custom field displays paused SLAs as PROGRESS 

("INDICATOR" = 'EXCEED' OR ("INDICATOR" = 'STILL' AND "EXPECTED_TARGET_DATE" < now())) AND "PAUSED" is false