Search using aliases
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 |
|---|---|---|---|---|
| slaOn | slaon | String | true/false | Whether or not the issue is in the 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 slaName = "p1" |
| 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
|
| 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 the current SLA - The Target Date. slaDate > 2020-01-01 slaDate > startOfMonth() slaDate > -1h |
| slaPaused | paused | String | "Paused" or "Not Paused" | slaPaused = "Paused" slaPaused != "Paused" slaPaused = "Not Paused" slaPaused = slaIsPaused() slaPaused != slaIsPaused() |
slaPausedDate | pauseddateiso | String | A string representation of a Date | The date of when the issue was paused. slaPausedDate > -2h slaPausedDate >-5h AND slaPausedDate <-2h slaPausedDate > 2020-05-11 AND slaPausedDate < 2020-05-12 slaPausedDate > startOfDay() --Paused today |
slaIssue | issueid | Number | The issue id (not issue key) | slaIssue in issueHistory()
slaIssue in updatedBy("mike")
|
slaFirstResponseStatus | frstatus | String | AHEAD, BEHIND, DELAYED, OK | slaFirstResponseStatus = BEHIND slaFirstResponseStatus != BEHIND slaFirstResponseStatus is EMPTY slaFirstResponseStatus is not EMPTY |
slaFirstResponseDate | frdateiso | Date | A string representation of a Date | slaFirstResponseDate > -2h slaFirstResponseDate >-5h AND slaFirstResponseDate <-2h slaFirstResponseDate > 2020-05-11 AND slaFirstResponseDate < 2020-05-12 slaFirstResponseDate > startOfDay() --First response today |
slaFirstResponseTime | frtime | Number | A positive integer | The time in seconds before first response was intiated. slaFirstResponseTime < slaToTime(2h)
slaFirstResponseTime < slaToTime("2h 8m 2s")
slaFirstResponseTime < slaToTime(02:08:02)
slaFirstResponseTime < 7682
|
It is not guaranteed 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].paused = "Paused" //issue is paused
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. |
| paused | String | "Paused" or "Not Paused" | If the issue is paused the value is "Paused". Otherwise null. Since version 2.3.5 |
| pauseddateiso | Date | A String representation of a Date | The time and date of when this issue was paused (if paused) Since version 2.3.5 |
| 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 |
| issueid | Number | Long | The issue id |
| projectid | Number | Long | The issue project id |
It is not guaranteed that an issue will contain all property keys.
All values can be empty or null (not existing).