JQL not returning any results

[R P]

So the problem is as follows:

This works - issue in tts.issuesWithExceededIndicator('SLA name') and project in (Project1, Project2, Project3, Project4, Project5) AND issuetype in (IssueType1, IssueType2) ORDER BY created ASC

This works - project in (Project1, Project2, Project3, Project4, Project5) AND issuetype in (IssueType1, IssueType2) AND created >= 2022-08-01 AND created <= 2022-12-31 ORDER BY created ASC

This one does not - issue in tts.issuesWithExceededIndicator('SLA name') and project in (Project1, Project2, Project3, Project4, Project5) AND issuetype in (IssueType1, IssueType2) AND created >= 2022-08-01 AND created <= 2022-12-31 ORDER BY created ASC

As you can see in the examples I run in to a problem where when TTS JQL is combined with a specific timeframe I get no results.

For example when searched by time frame there is 1004 issues, but when those two search criteria are combined nothing is shown, and in system logs it is visible that there is an error that by that combined search criteria systems tries to show 90+k issues, thus does not return anything to not overload system.

Where could be the problem, why these two criterias does not work alongside each other? Is there another way to filter specific SLA in specific timeframe?

[Tuncay Senturk]

Hi @R P 

Welcome to the Community!

Which version of TTS are you using? As documented here, SLA 2.0 search functions do not work with next gen SLAs. You need to use SLA 3.0 functions (counterpart JQLs are listed in the documentation page, please check).

Thanks!

[R P]

A BIG thanyou! Saved me a lot of time. No idea how I red past that big red text about incompatibility with 2.0 JQLs. Tested it out with 3.0 and it works.

[Tuncay Senturk]

Perfect! Glad that it works!