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

JQL to extract all tickets not updated within the last 2 or 3 business days

Karyn Tooke
Contributor
March 25, 2020

Similar to this post about finding tickets updated on a Friday, we need a way to list all tickets that have not been updated by an agent within the last 2 or 3 days excluding weekends/non-working days such as bank holidays. Current filter (which currently includes weekends):

status not in ("On Hold - Not prioritised", Rejected, Resolved, Closed, Cancelled) AND updated <= -5d ORDER BY updated ASC

If anyone knows how to add the agent part too that would be awesome as currently the above includes both agent & customer updates.

We then want to display this data in a filter results gadget.

0 comments

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events