tickets created yesterday only - JQL

[Szymon Pochopien]

Hi

I am looking to check if my query fits my requirements correctly. I need to check tickets were created yesterday only, not today breached their SLA:

Will this give me the correct results?

created > -1d AND "Time to Resolution" = breached()

[Sreenivasaraju P · Accepted solution]

Hi @Szymon Pochopien ,

You can try below query. I hope this query may help you.

created < startOfDay() AND created >= startOfDay(-1) and "Time to Resolution" = breached()

[Szymon Pochopien]

Thank you for your quick reply, have a nice day:)

[John M Funk · Accepted solution]

Hi Szymon,

That should work. Give it a try and see. 

[Szymon Pochopien]

Confirmed, thank you:)