Searching against SLA Value returns no results

[Clayton Chancey]

I'm operating a JSD (cloud) project with about 20,000 resolved issues, each with data tracked for the "Time to resolution" SLA.

I'm running the following query and getting 0 results:

project = ITHELP AND statusCategory = Done AND resolved > startOfMonth() AND "Time to resolution" != breached() AND "Time to resolution" <= elapsed("24h")

When I remove the final statement (AND "Time to resolution <= elapsed("24h")) the query returns results as expected - many of which show a "Time to resolution" value of less than 24 hours.

The SLA itself is set at 72h on a 9-5 Calendar, for a specific subset of issuetypes, but otherwise no complex overlapping JQL.

I have no idea why I cannot seem to search against the SLA value on these issues. Help!

[Clayton Chancey]

*sorry, accidentally replied here. Edited to reply above

[Cristian Rosas [Tecnofor]]

Your query says:

Return issues which hasn't breached SLA Time to Resolution, and still haven't passed 24 hours (in your calendar configuration) since the SLA has been active. 

Is it correct?

It's weird to have 0 results in that query, but not impossible. Try to say >= and it would mean:

Return issues which hasn't breached SLA Time to Resolution, and have already passed 24 hours (in your calendar configuration) since the SLA has been active. 

And you will see if the result is correct or you just misstyped.

[Clayton Chancey]

Hi @Cristian Rosas -Tecnofor-,

The purpose of the query is to identify tickets that were resolved within 1 business day, even though we have a 72 hr SLA for time to resolution. All of these tickets should be closed (hence the bit about "statusCategory=Done"), but I am trying to filter those based on how much time elapsed against the "Time to resolution" SLA. Does that clarify?

[Cristian Rosas [Tecnofor]]

I understand now. I think you will need a new SLA for that metric...  As it is defined:

Returns issues whose SLA clock is at a certain point relative to a cycle's start event.  

Looks like the relative point dissapear one the SLA has been achieved or missed

[Clayton Chancey]

@Cristian Rosas [Tecnofor]  Sorry for my delay in responding. So, I'm ultimately looking for JQL that searches against the SLA stat for a resolved issue. If "elapsed()" won't work, I need something that does. For example: when I run the following JQL I don't get any results either, but the static type checking doesn't throw any JQL errors to indicate wrong formatting.

roject = ITHELP AND statusCategory = Done AND resolved > startOfMonth() AND "Time to resolution" != breached() AND "Time to resolution" <= 24h