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 ASCIf 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.
