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.

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')