Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,462,680
Community Members
 
Community Events
176
Community Groups

JQL not returning any results

R P I'm New Here Jan 24, 2023

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?

1 answer

0 votes
Tuncay Senturk Community Leader Jan 24, 2023

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 I'm New Here Jan 24, 2023

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.

Like Tuncay Senturk likes this
Tuncay Senturk Community Leader Jan 24, 2023

Perfect! Glad that it works!

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events