Atlassian Marketplace Request a demo Raise a ticket

SLA Search 2.0 JQL Functionalities

This page is about Time to SLA for Jira Server users.


Please bear in mind that SLA Search 2.0 JQL functions don't work with Next-Gen SLAs. Please use search 3.0 functions instead.

JQL Function

Parameters

Description

Samples

tts.issuesHaveSomeSlas 

  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that have SLAs on them.
  • issue in tts.issuesHaveSomeSlas()
  • issue in tts.issuesHaveSomeSlas(22)
  • issue in tts.issuesHaveSomeSlas('SLA Name')
  • issue in tts.issuesHaveSomeSlas(22, 23, 30)
  • issue in tts.issuesHaveSomeSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesHaveSomeSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesHaveSomeMetSlas

  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that met at least one SLA.
  • issue in tts.issuesHaveSomeMetSlas()
  • issue in tts.issuesHaveSomeMetSlas(22)
  • issue in tts.issuesHaveSomeMetSlas('SLA Name')
  • issue in tts.issuesHaveSomeMetSlas(22, 23, 30)
  • issue in tts.issuesHaveSomeMetSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesHaveSomeMetSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesHaveSomeExceededSlas

  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that breached at least one SLA.

(Not Completed SLAs are included)

  • issue in tts.issuesHaveSomeExceededSlas()
  • issue in tts.issuesHaveSomeExceededSlas(22)
  • issue in tts.issuesHaveSomeExceededSlas('SLA Name')
  • issue in tts.issuesHaveSomeExceededSlas(22, 23, 30)
  • issue in tts.issuesHaveSomeExceededSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesHaveSomeExceededSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesHaveSomeSlasInProgress

  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that have at least one not completed and not breached SLA.
  • issue in tts.issuesHaveSomeSlasInProgress()
  • issue in tts.issuesHaveSomeSlasInProgress(22)
  • issue in tts.issuesHaveSomeSlasInProgress('SLA Name')
  • issue in tts.issuesHaveSomeSlasInProgress(22, 23, 30)
  • issue in tts.issuesHaveSomeSlasInProgress('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesHaveSomeSlasInProgress('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31

tts.issuesHaveSomeInactiveSlas 

  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To find inactive SLAs.

(Inactive SLAs may have missing date fields.)

  • issue in tts.issuesHaveSomeInactiveSlas()
  • issue in tts.issuesHaveSomeInactiveSlas(22)
  • issue in tts.issuesHaveSomeInactiveSlas('SLA Name')
  • issue in tts.issuesHaveSomeInactiveSlas(22, 23, 30)
  • issue in tts.issuesHaveSomeInactiveSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesHaveSomeInactiveSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesHaveSomePausedSlas

  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that have at least one paused SLA.
  • issue in tts.issuesHaveSomePausedSlas()
  • issue in tts.issuesHaveSomePausedSlas(22)
  • issue in tts.issuesHaveSomePausedSlas('SLA Name')
  • issue in tts.issuesHaveSomePausedSlas(22, 23, 30)
  • issue in tts.issuesHaveSomePausedSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesHaveSomePausedSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesHaveAllSlasMet

  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that met all its SLAs.
  • issue in tts.issuesHaveAllSlasMet()
  • issue in tts.issuesHaveAllSlasMet(22)
  • issue in tts.issuesHaveAllSlasMet('SLA Name')
  • issue in tts.issuesHaveAllSlasMet(22, 23, 30)
  • issue in tts.issuesHaveAllSlasMet('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesHaveAllSlasMet('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesHaveNoExceededSlas

  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that have not exceeded any of its SLAs.
  • issue in tts.issuesHaveNoExceededSlas()
  • issue in tts.issuesHaveNoExceededSlas(22)
  • issue in tts.issuesHaveNoExceededSlas('SLA Name')
  • issue in tts.issuesHaveNoExceededSlas(22, 23, 30)
  • issue in tts.issuesHaveNoExceededSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesHaveNoExceededSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesExceededAmongCompletedSlas 

  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that exceeded at least one completed SLA.
  • issue in tts.issuesExceededAmongCompletedSlas()
  • issue in tts.issuesExceededAmongCompletedSlas(22)
  • issue in tts.issuesExceededAmongCompletedSlas('SLA Name')
  • issue in tts.issuesExceededAmongCompletedSlas(22, 23, 30)
  • issue in tts.issuesExceededAmongCompletedSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesExceededAmongCompletedSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesExceededAmongUncompletedSlas 

  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that exceeded at least one uncompleted SLA.
  • issue in tts.issuesExceededAmongUncompletedSlas()
  • issue in tts.issuesExceededAmongUncompletedSlas(22)
  • issue in tts.issuesExceededAmongUncompletedSlas('SLA Name')
  • issue in tts.issuesExceededAmongUncompletedSlas(22, 23, 30)
  • issue in tts.issuesExceededAmongUncompletedSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesExceededAmongUncompletedSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesNotExceededAmongCompletedSlas

  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that have not exceeded any of its completed SLAs
  • issue in tts.issuesNotExceededAmongCompletedSlas()
  • issue in tts.issuesNotExceededAmongCompletedSlas(22)
  • issue in tts.issuesNotExceededAmongCompletedSlas('SLA Name')
  • issue in tts.issuesNotExceededAmongCompletedSlas(22, 23, 30)
  • issue in tts.issuesNotExceededAmongCompletedSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesNotExceededAmongCompletedSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesNotExceededAmongUncompletedSlas

  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that have not exceeded any of its uncompleted SLAs.
  • issue in tts.issuesNotExceededAmongUncompletedSlas()
  • issue in tts.issuesNotExceededAmongUncompletedSlas(22)
  • issue in tts.issuesNotExceededAmongUncompletedSlas('SLA Name')
  • issue in tts.issuesNotExceededAmongUncompletedSlas(22, 23, 30)
  • issue in tts.issuesNotExceededAmongUncompletedSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesNotExceededAmongUncompletedSlas('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithRemainingTimeMoreThan

  • Timestring (required)
  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that have more remaining time than the given parameter.

(Completed SLAs are not included.)


  • issue in tts.issuesWithRemainingTimeMoreThan('3h')
  • issue in tts.issuesWithRemainingTimeMoreThan('2d 4h', 22)
  • issue in tts.issuesWithRemainingTimeMoreThan('2d 4h', 'SLA Name')
  • issue in tts.issuesWithRemainingTimeMoreThan('3d 5h', 22, 23, 30)
  • issue in tts.issuesWithRemainingTimeMoreThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithRemainingTimeMoreThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')


tts.issuesWithRemainingTimeLessThan

  • Timestring (required)
  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that have less remaining time than the given parameter.

(Completed SLAs are not included.)

  • issue in tts.issuesWithRemainingTimeLessThan('3h')
  • issue in tts.issuesWithRemainingTimeLessThan('2d 4h', 22)
  • issue in tts.issuesWithRemainingTimeLessThan('2d 4h', 'SLA Name')
  • issue in tts.issuesWithRemainingTimeLessThan('3d 5h', 22, 23, 30)
  • issue in tts.issuesWithRemainingTimeLessThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithRemainingTimeLessThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithBreachLongerThan

  • Timestring (required)
  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that have a breach longer than the given parameter.
  • issue in tts.issuesWithBreachLongerThan('3h')
  • issue in tts.issuesWithBreachLongerThan('2d 4h', 22)
  • issue in tts.issuesWithBreachLongerThan('2d 4h', 'SLA Name')
  • issue in tts.issuesWithBreachLongerThan('3d 5h', 22, 23, 30)
  • issue in tts.issuesWithBreachLongerThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithBreachLongerThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithBreachShorterThan

  • Timestring (required)
  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that have a breach shorter than the given parameter.
  • issue in tts.issuesWithBreachShorterThan('3h')
  • issue in tts.issuesWithBreachShorterThan('2d 4h', 22)
  • issue in tts.issuesWithBreachShorterThan('2d 4h', 'SLA Name')
  • issue in tts.issuesWithBreachShorterThan('3d 5h', 22, 23, 30)
  • issue in tts.issuesWithBreachShorterThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithBreachShorterThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithBreachLongerThanAmongCompletedSlas

  • Timestring (required)
  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that have a breach longer than the given parameter among completed SLAs.

(Uncompleted SLAs are not included.)

  • issue in tts.issuesWithBreachLongerThanAmongCompletedSlas('3h')
  • issue in tts.issuesWithBreachLongerThanAmongCompletedSlas('2d 4h', 22)
  • issue in tts.issuesWithBreachLongerThanAmongCompletedSlas('2d 4h', 'SLA Name')
  • issue in tts.issuesWithBreachLongerThanAmongCompletedSlas('3d 5h', 22, 23, 30)
  • issue in tts.issuesWithBreachLongerThanAmongCompletedSlas('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithBreachLongerThanAmongCompletedSlas('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithBreachLongerThanAmongUncompletedSlas

  • Timestring (required)
  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that have a breach longer than the given parameter among uncompleted SLAs.

(Completed SLAs are not included.)

  • issue in tts.issuesWithBreachLongerThanAmongUncompletedSlas('3h')
  • issue in tts.issuesWithBreachLongerThanAmongUncompletedSlas('2d 4h', 22)
  • issue in tts.issuesWithBreachLongerThanAmongUncompletedSlas('2d 4h', 'SLA Name')
  • issue in tts.issuesWithBreachLongerThanAmongUncompletedSlas('3d 5h', 22, 23, 30)
  • issue in tts.issuesWithBreachLongerThanAmongUncompletedSlas('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithBreachLongerThanAmongUncompletedSlas('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithBreachShorterThanAmongCompletedSlas 

  • Timestring (required)
  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that have a breach shorter than the given parameter among completed SLAs.

(Uncompleted SLAs are not included.)

  • issue in tts.issuesWithBreachShorterThanAmongCompletedSlas('3h')
  • issue in tts.issuesWithBreachShorterThanAmongCompletedSlas('2d 4h', 22)
  • issue in tts.issuesWithBreachShorterThanAmongCompletedSlas('2d 4h', 'SLA Name')
  • issue in tts.issuesWithBreachShorterThanAmongCompletedSlas('3d 5h', 22, 23, 30)
  • issue in tts.issuesWithBreachShorterThanAmongCompletedSlas('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithBreachShorterThanAmongCompletedSlas('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithBreachShorterThanAmongUncompletedSlas

  • Timestring (required)
  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that have a breach shorter than the given parameter among uncompleted SLAs.

(Completed SLAs are not included.)

  • issue in tts.issuesWithBreachShorterThanAmongUncompletedSlas('3h')
  • issue in tts.issuesWithBreachShorterThanAmongUncompletedSlas('2d 4h', 22)
  • issue in tts.issuesWithBreachShorterThanAmongUncompletedSlas('2d 4h', 'SLA Name')
  • issue in tts.issuesWithBreachShorterThanAmongUncompletedSlas('3d 5h', 22, 23, 30)
  • issue in tts.issuesWithBreachShorterThanAmongUncompletedSlas('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithBreachShorterThanAmongUncompletedSlas('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithMetIndicator

  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that have a MET indicator. 

This method does the same job with tts.issuesHaveAllSlasMet method.

(An issue has a MET indicator if it has met all its SLAs.)

  • issue in tts.issuesWithMetIndicator()
  • issue in tts.issuesWithMetIndicator(22)
  • issue in tts.issuesWithMetIndicator('SLA Name')
  • issue in tts.issuesWithMetIndicator(22, 23, 30)
  • issue in tts.issuesWithMetIndicator('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithMetIndicator('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithProgressIndicator 

  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that have a PROGRESS indicator. 

(An issue has a PROGRESS indicator if it has at least one progressing SLA and has not exceeded any of its SLAs.)

  • issue in tts.issuesWithProgressIndicator()
  • issue in tts.issuesWithProgressIndicator(22)
  • issue in tts.issuesWithProgressIndicator('SLA Name')
  • issue in tts.issuesWithProgressIndicator(22, 23, 30)
  • issue in tts.issuesWithProgressIndicator('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithProgressIndicator('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithExceededIndicator

  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that have a EXCEEDED indicator. 

This method does the same job with tts.issuesHaveSomeExceededSlas method.

(An issue has a EXCEEDED indicator if it exceeded at least one of its SLAs.)

  • issue in tts.issuesWithExceededIndicator()
  • issue in tts.issuesWithExceededIndicator(22)
  • issue in tts.issuesWithExceededIndicator('SLA Name')
  • issue in tts.issuesWithExceededIndicator(22, 23, 30)
  • issue in tts.issuesWithExceededIndicator('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithExceededIndicator('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithInactiveIndicator 

  • SLA Id or SLA Name
  • Date Filtering Map Parameters

To filter issues that have a INACTIVE indicator. 

(An issue has a INACTIVE indicator if its all SLAs are inactive.)

  • issue in tts.issuesWithInactiveIndicator()
  • issue in tts.issuesWithInactiveIndicator(22)
  • issue in tts.issuesWithInactiveIndicator('SLA Name')
  • issue in tts.issuesWithInactiveIndicator(22, 23, 30)
  • issue in tts.issuesWithInactiveIndicator('SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issuesWithInactiveIndicator('SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2017-01-01', 'startedBefore:2017-12-31')

tts.issuesWithElapsedTimeMoreThan

  • Timestring (required)
  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that have elapsed time more than the given parameter.
  • issue in tts.issueWithElapsedTimeMoreThan('3h')
  • issue in tts.issueWithElapsedTimeMoreThan('2d 4h', 22)
  • issue in tts.issueWithElapsedTimeMoreThan('2d 4h', 'SLA Name')
  • issue in tts.issueWithElapsedTimeMoreThan('3d 5h', 22, 23, 30)
  • issue in tts.issueWithElapsedTimeMoreThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issueWithElapsedTimeMoreThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2019-04-23', 'startedBefore:2019-10-29')

tts.issuesWithElapsedTimeLessThan

  • Timestring (required)
  • SLA Id or SLA Name
  • Date Filtering Map Parameters
To filter issues that have elapsed time less than the given parameter.
  • issue in tts.issueWithElapsedTimeLessThan('3h')
  • issue in tts.issueWithElapsedTimeLessThan('2d 4h', 22)
  • issue in tts.issueWithElapsedTimeLessThan('2d 4h', 'SLA Name')
  • issue in tts.issueWithElapsedTimeLessThan('3d 5h', 22, 23, 30)
  • issue in tts.issueWithElapsedTimeLessThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3')
  • issue in tts.issueWithElapsedTimeLessThan('3d 5h', 'SLA Name 1', 'SLA Name 2', 'SLA Name 3', 'startedAfter:2019-04-23', 'startedBefore:2019-10-29')