Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I get all tickets that have less than 0 SLA remaining

Hello,

I'm using the Time To SLA plugin in the project that I'm working on.

I'm trying to make a JQL request that would return all late tickets, something that would look like this:

"Remaining SLA" < 0d

But I get an error stating that the operator '<' cannot be used in this case.

Can anyone help me ?

2 answers

Hey @sheikh-spear ,

If they have 0 time left they would be breached so you could use that to find them.

example: "Time to resolution" = breached()

So you could put your "name of SLA" = breached() and those will return the issues that are breached.

You might want to also add a "AND "name of SLA" = running() to get only the issues that are still ongoing. (or another filter to don't get the historically breached ones)

It's tells me that it doesn't reconize breached as a function :(

Dirk Ronsmans Community Leader May 03, 2021

That's weird cause it's a out of the box function.

Did you put breached or breached() 

Those brackets are required :)

Otherwise a screenshot to see what's going on might help!

Here is the screenshot, thanks in advance Jira help anonyme.png

Dirk Ronsmans Community Leader May 03, 2021

Hey @sheikh-spear

Could you try the JQL on a regular issue search (and not on the gadget)?

It seems that gadget is from an app so it could be they don't support it. If it works on a normal advanced issue search I'd suggest opening up a ticket with them on their portal

https://qotilabs.atlassian.net/servicedesk/customer/portal/5

It doesn't work either way

Capture.PNG

Dirk Ronsmans Community Leader May 03, 2021

Very strange.. breached() is something that exists since a long time already.

https://confluence.atlassian.com/servicemanagementserver/using-jql-queries-specific-to-slas-939926424.html

Could you maybe do a type ahead to see what happens? (maybe the language is messing with us)

image.png

 

When I type my SLA's name and then the = mark I'm presented with all the options.

You are using Service Desk SLA's right? 

No the name of the plugin is Time To SLA

Dirk Ronsmans Community Leader May 03, 2021

Then I suggest taking a look at their JQL functions list:

https://confluence.snapbytes.com/time-to-sla/sla-search/sla-search-2-0-jql-functionalities

these really depend on the version of your plugin

Hi @sheikh-spear ,

This is Gökçe From the Snapbytes team.

We recommend using the Search 3.0. for this.

For your use case slaFunction= isBreached() would do nicely.

It has functions for remainingDuration, elapsedDuration , remainingPercentage and elapsedPercentage functions you can use.

https://confluence.snapbytes.com/display/TTSToggle/SLA+Search+3.0+JQL+Functionalities

For further support, you can open a support request here: Time to SLA Customer Portal

Please let me know if you have further questions.

Regards,

Gökçe

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you