Page tree
Skip to end of metadata
Go to start of metadata

Required knowledge

This page requires some knowledge of searching for issues using JQL. If you are in need of a detailed introduction on JQL usage, please click here to get more information. Due to the Issue Navigator limitations, it's not possible to search for the SLAs in the Basic mode.

What is slaFunction?

slaFunction is a custom field that will be added automatically by the plugin. It can only be used for JQL search and cannot be added to any screens like other custom fields. This design allows a better plugin performance. Click here if you want to check out old JQL functions.

1. State Functions

These functions are used for filtering issues that have a given SLA state. As these functions are used for checking state equality, they can only be used with operands '=' and '!='.

1.1. isNotStarted

isNotStarted([Optional List of SLA IDs])


In the simplest form, issues that have at least one inactive SLA can be searched.

Find issues that have at least one inactive SLA.
slaFunction = isNotStarted()


Alternatively, issues with SLAs that have not started for the given SLA ids can be searched:

Find issues that have at least one inactive SLA for SLAs with IDs 1, 12, 30.
slaFunction = isNotStarted(1,12,30)

1.2. isFinished

isFinished([Optional List of SLA IDs])


In the simplest form, issues that have at least one finished SLA can be searched.

Find issues that have at least one finished SLA.
slaFunction = isFinished()


Alternatively ,issues with finished SLAs for the given SLA ids can be searched:

Find issues that have at least one finished SLA for SLAs with IDs 2, 4, 11.
slaFunction = isFinished(2,4,11)

1.3. isRunning

isRunning([Optional List of SLA IDs])


In the simplest form, issues that have at least one running SLA can be searched.

Find issues that have at least one running SLA.
slaFunction = isRunning()


Alternatively, issues with running SLAs for the given SLA ids can be searched:

Find issues that have at least one running SLA for SLAs with IDs 3, 7, 9.
slaFunction = isRunning(3,7,9)

1.4. isPaused

isPaused([Optional List of SLA IDs])


In the simplest form, issues that have at least one paused SLA can be searched.

Find issues that have at least one paused SLA.
slaFunction = isPaused()


Alternatively, issues with paused SLAs for the given SLA ids can be searched:

Find issues that have at least one paused SLA for SLAs with IDs 4, 10.
slaFunction = isPaused(4,10)

2. Duration Functions

These functions are used for filtering issues by their SLA durations. Since these functions are used for duration comparison, they can only be used with operands '>', '>=', '<' and '<='. Calendars of the SLAs are taken into consideration while interpreting the given duration strings.

2.1. remainingDuration

remainingDuration(Duration, [Optional List of SLA IDs])


This function compares the given duration with the remaining duration of SLAs:

Find issues that have at least one SLA with remaining duration less than or equals to 4 hours.
slaFunction <= remainingDuration("4h")
Find issues that have at least one SLA with remaining duration more than 2 days.
slaFunction > remainingDuration("2d")


Alternatively, this function compares a given duration with remaining duration of given SLAs specified by SLA ids:

Find issues that have at least one SLA with remaining duration less than 1 day for SLAs with IDs 5, 7.
slaFunction < remainingDuration("1d", 5, 7)
Find issues that have at least one SLA with remaining duration more than or equals to 5 days for SLAs with IDs 2, 6, 12.
slaFunction >= remainingDuration("5d", 2, 6, 12)

2.2. elapsedDuration

elapsedDuration(Duration, [Optional List of SLA IDs])


This function compares the given duration with elapsed duration of SLAs and returns issues that fit the criteria:

Find issues that have at least one SLA with elapsed duration less than or equals to 3 hours.
slaFunction <= elapsedDuration("3h")
Find issues that have at least one SLA with elapsed duration more than 5 days.
slaFunction > elapsedDuration("5d")


Alternatively, this function compares a given duration with elapsed duration of SLAs specified by their ids:

Find issues that have at least one SLA with elapsed duration less than 2 days for SLAs with IDs 1, 8, 11.
slaFunction < elapsedDuration("2d", 1, 8, 11)
Find issues that have at least one SLA with elapsed duration more than or equals to 5 hours for SLAs with IDs 3, 5.
slaFunction >= elapsedDuration("5h", 3, 5)

2.3. breachDuration

breachDuration(Duration, [Optional List of SLA IDs])


This function compares the given duration with breach duration of SLAs:

Find issues that have at least one SLA with breach duration more than or equals to 2 hours.
slaFunction >= breachDuration("2h")
Find issues that have at least one SLA with brech duration less than 1 day.
slaFunction < breachDuration("1d")


Alternatively, this function compares a given duration with breach duration of SLAs specified by their ids:

Find issues that have at least one SLA with breach duration more than 4 days for SLAs with IDs 3, 4.
slaFunction > breachDuration("4d", 3, 4)
Find issues that have at least one SLA with breach duration less than or equals to 4 hours for SLAs with IDs 2, 9, 15.
slaFunction <= breachDuration("4h", 2, 9, 15)

3. Date Functions

These functions are used for filtering issues by SLA date values. As these functions are used for date comparison, they can only be used with operands '>', '>=', '<' and '<='. If duration strings are used instead of giving an exact date to compare to, calendars of the SLAs will be taken into consideration while interpreting them.

3.1. slaStartDate

slaStartDate(Date or Duration, [Optional List of SLA IDs])


This function compares the given date or duration string with the start date of SLAs:

Finds issues that have at least one SLA that has started on or before July 1, 2019.
slaFunction <= slaStartDate("2019-07-01")
Finds issues that have at least one SLA that has started at most 5 calendar day ago.
slaFunction < slaStartDate("-5d")

Alternatively, this function compares a given date or duration string with the start date of the SLAs specified by their ids:

Finds issues that have at least one SLA which has started in the last 20 calendar day for SLAs with IDs 4, 6, 8.
slaFunction > slaStartDate("-20d", 4, 6, 8)
Finds issues that have at least one SLA that started on or after April 1, 2019 at 13:00 for SLAs with IDs 1, 2.
slaFunction >= slaStartDate("2019-04-01 13:00", 1, 2)

3.2. slaTargetDate

slaTargetDate(Date or Duration, [Optional List of SLA IDs])


This function compares the given date or duration string with target date of SLAs and returns issues that fit the criteria:

Find issues that have at least one SLA that is targeted before Januray 1, 2020.
slaFunction < slaTargetDate("2020-01-01")
Find issues that have at least one SLA which is targeted to at most next 2 calendar days.
slaFunction <= slaTargetDate("2d")

Alternatively, this function compares a given date or duration string with target date of the SLAs specified by their ids:

Find issues that have at least one SLA which is targeted to the last 20 calendar days for SLAs with IDs 5, 7, 8.
slaFunction > slaTargetDate("-20d", 5, 7, 8)
Find issues that have at least one SLA that is targeted to or after November 11, 2019 at 08:00 for SLAs 7, 9.
slaFunction >= slaTargetDate("2019-11-01 08:00", 7, 9)

3.3. slaEndDate

slaEndDate(Date or Duration, [Optional List of SLA IDs])


This function compares the given date or duration with end date of SLAs and returns issues that fit the criteria:

Find issues that have at least one SLA that has ended before October 31, 2019.
slaFunction < slaEndDate("2019-10-31")
Find issues that have at least one SLA that has ended at most 2 calendar days ago.
slaFunction <= slaEndDate("-2d")


Alternatively, this function compares a given date or duration with end date of the SLAs specified by their ids:

Find issues that have at least one SLA that has ended in the last 10 calendar days for SLAs with IDs 5, 7, 8.
slaFunction > slaEndDate("-10d", 5, 7, 8)
Find issues that have at least one SLA that has ended on or after June 30, 2019 at 17:00 for SLAs 7, 9.
slaFunction >= slaEndDate("2019-06-30 17:00", 7, 9)

4. Percentage Functions

These functions are used for filtering issues by elapsed or remaining percentage of SLAs. As these functions are used for percentage comparison, they can only be used with operands '>', '>=', '<' and '<='. Only the following percentage values are valid for comparison: 10, 20, 25, 30, 40, 50, 60, 70, 75, 80, 90

4.1. remainingPercentage

remainingPercentage(Percentage, [Optional List of SLA IDs])


This function compares the given percent with remaining percentage of SLAs and returns issues that fit the criteria:

Find issues that have at least one SLA with remaining percentage less than or equals to 10 percent.
slaFunction <= remainingPercentage(10)
Find issues that have at least one SLA with remaining percentage more than 75 percent.
slaFunction > remainingPercentage(75)


Alternatively, this function compares a given duration with remaining percentage of the SLAs specified by their ids:

Find issues that have at least one SLA with remaining percentage less than 25 percent for SLAs with IDs 5, 7.
slaFunction < remainingPercentage(25, 5, 7)
Find issues that have at least one SLA with remaining duration more than or equals to 5 days for SLAs with IDs 2, 6, 12.
slaFunction >= remainingPercentage(50, 2, 6, 12)

4.2. elapsedPercentage

elapsedPercentage(Percent, [Optional List of SLA IDs])


This function compares the given duration with elapsed percentage of SLAs and returns issues that fit the criteria:

Find issues that have at least one SLA with elapsed percentage less than or equals to 20 percent.
slaFunction <= elapsedPercentage(20)
Find issues that have at least one SLA with elapsed percentage more than 80 percent.
slaFunction > elapsedPercentage(80)


Alternatively the function compares a given duration with elapsed percentage of the given SLAs specified by their ids:

Find issues that have at least one SLA with elapsed percentage less than 40 percent for SLAs with IDs 1, 8, 11.
slaFunction < elapsedPercentage(40, 1, 8, 11)
Find issues that have at least one SLA with elapsed duration more than or equals to 75 percent for SLAs with IDs 3, 5.
slaFunction >= elapsedPercentage(75, 3, 5)

5. Breach Function

This function is used for checking the breach state of the SLAs. Since this function is used for checking state equality, it can only be used with operands '=' and '!='.

5.1. isBreached

isBreached([Optional List of SLA IDs])


This function searches for issues that have at least one breached SLA.

Find issues that have at least one breached SLA.
slaFunction = isBreached()


Alternatively issues with breached SLAs specified by SLA ids can be searched:

Find issues that have at least one breached SLA for SLAs with IDs 1, 12, 30.
slaFunction = isBreached(1,12,30)


Function name clashes with other apps

Some other plugin may provide functions with the same name as those provided by Time to SLA such as isNotStarted. For functions like these, no other name would make a great deal of sense, so this is not surprising. The protocol for these situations are explained in JRA-24219, i.e, the plugin key that is first alphabetically will "win".


  • No labels