The add-on enables precise and accurate searching for SLA issues.
JQL Functions
See JQL Functions
Alias Searching
Available app version 2.3.5.
SLA Issue Properties can be searched using alias names making it faster and more intuitive to search for issues with SLA Values.
| Alias | Key | Type | Value | Description |
|---|---|---|---|---|
| sla | String | any | The id of the current or last used SLA | |
| slaOn | slaon | String | true/false | Whether or not the issue is in scope of a SLA slaOn = "true" slaOn = "false" slaOn is Empty slaOn in slaIsOn() slaOn not in slaIsOn() |
| slaName | slaname | String | any | The name of the current or last used SLA |
| slatime | Number | A positive integer | The SLA Target Time in seconds | |
| slaSpentTime | time | Number | A positive integer | The Time Spent in seconds slaSpentTime < slaToTime(2h)
slaSpentTime < slaToTime("2h 8m 2s")
slaSpentTime < slaToTime(02:08:02)
slaSpentTime < 7682
|
| status | String | Any value that matches the id of a SLA Status | The id of the current SLA Status. | |
| slaDate | dateiso | Date | A String representation of a Date | The time and date of when SLA Values was updated by the Add-on slaDate > 2020-01-01 slaDate > startOfMonth() slaDate > -1h |
| slaETA | etaiso | Date | A String representation of a Date | The time and date of when the issue should be completed with current SLA - The Target Date. slaDate > 2020-01-01 slaDate > startOfMonth() slaDate > -1h |
| forcedstate.state | Number | 0 or 1 | If the issue is paused the value will be 1. Otherwise empty or 0 Since version 1.5.0 | |
| forcedstate.dateiso | Date | A String representation of a Date | The time and date of when this issue was paused (if paused) Since version 1.5.0 | |
| percent | Number | A positive integer | The percent value of Time Spent compared to the SLA Target Time | |
| customslatime | String | true/false | Whether or not the issue has a custom SLA Target Time (The SLA Target Time has been overriden) | |
| frstatus | String | AHEAD, BEHIND, OK or DELAYED | The id of the current First Response Status | |
| frtime | Number | A positive integer | The time spent before First Response was initiated | |
| frslatime | Number | A positive integer | The SLA First Response Target Time in seconds |
It is not guarantied that an issue will contain all property keys.
Issue Property Searching
All issue SLA Values are stored as issue properties and as such enables fast and effective JQL searching.
You can search for all SLA values on the form issue.property[slatimer].x = y where x is the key and y the search value.
Examples:
issue.property[slatimer].sla in slaName("P1","P2:) //issue with a sla named p1 or P2
issue.property[slatimer].slaname = "p1" //issuea with a sla named p1
issue.property[slatimer].time = 3600 //spent time is equal to 1 hour = 3600 seconds
issue.property[slatimer].time = slaToSecons("1h") //spent time is equal to 1 hour = 3600 seconds
issue.property[slatimer].etaiso > now() //target date less than current date and time
issue.property[slatimer].forcedstate.state = 1 //paused issues
SLA Values
The SLA Values are the values the Add-on stores for an issue.
| Key | Type | Value | Description |
|---|---|---|---|
| sla | String | any | The id of the current or or last used SLA |
| slaon | String | true/false | Whether or not the issue is in scope of a SLA |
| slaname | String | any | The name of the current or last used SLA |
| slatime | Number | A positive integer | The SLA Target Time in seconds |
| time | Number | A positive integer | The Time Spent in seconds |
| status | String | Any value that matches the id of a SLA Status | The id of the current SLA Status. |
| dateiso | Date | A String representation of a Date | The time and date of when SLA Values was updated by the Add-on |
| etaiso | Date | A String representation of a Date | The time and date of when the issue should be completed with current SLA - The Target Date. |
| forcedstate.state | Number | 0 or 1 | If the issue is paused the value will be 1. Otherwise empty or 0 Since version 1.5.0 |
| forcedstate.dateiso | Date | A String representation of a Date | The time and date of when this issue was paused (if paused) Since version 1.5.0 |
| percent | Number | A positive integer | The percent value of Time Spent compared to the SLA Target Time |
| customslatime | String | true/false | Whether or not the issue has a custom SLA Target Time (The SLA Target Time has been overriden) |
| frstatus | String | AHEAD, BEHIND, OK or DELAYED | The id of the current First Response Status |
| frtime | Number | A positive integer | The time spent before First Response was initiated |
| frslatime | Number | A positive integer | The SLA First Response Target Time in seconds |
It is not guarantied that an issue will contain all property keys.
All values can be empty or null (not existing).