Create Sign up

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.

Get started Tell me more

4,462,809

Community Members

Community Events

176

Community Groups

Community
Products
Jira Work Management
Questions
tickets created yesterday only - JQL

tickets created yesterday only - JQL

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()

2 answers

2 accepted

1 vote

Answer accepted

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()

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • John Funk likes this

0 votes

Answer accepted

Hi Szymon,

That should work. Give it a try and see.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Confirmed, thank you:)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • John Funk likes this

Suggest an answer

Was this helpful?

Thanks!

Jira Work Management

Products

Community resources

Support

Interests

Community resources

Support

Top groups

Community resources

Support

Earn badges and make progress

Participate in fun challenges

Gift kudos to your peers

Rise up in the ranks

Come for the products,
stay for the community

tickets created yesterday only - JQL