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

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

Cannnot pull closed tickets that have elapsed SLA

When pulling closed tickets for my team I get no issues but when I add my SLA counter ("Time to customer resolution" > elapsed(2h45m)) the query doesn't pull any tickets. I have verified that I have tickets that have elapsed that 2h45m window as well. 

 

When I remove the part in my query about the tickets needing to be closed I get results but they aren't what I need because I need Closed tickets that have elapsed the "Time to Customer Resolution" SLA.

2 answers

0 votes

Can you paste your exact JQL here? 

project = "IT Help Desk" AND status = Closed AND resolutiondate > startOfDay(-1) AND resolutiondate < endOfDay(-1) AND assignee = ataylor and "Time to customer resolution" > elapsed("2h45m")

Can you please post a ticket you are expecting to have returned by the query? Make sure to redact any sensative info. 

0 votes
If you get results on removing just "Status = Closed" from that JQL, it means that the resolution field is being set in a previous status, ie: Resolved.

The query is ok, but the resolution date is not the same date when the issue moved to the Closed status.

You may want to change your JQL by substituting the references to the Resolution Date to:

Status changed to Closed after startOfDay(-1) before startOfDay()

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,346 views 22 31
Read article

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