What query can I use to pull up a link for tickets completed within the last month to include in my monthly reports?
Hi @Ernest Nji ,
What you mean by completed, tickets moved to completed status or moved to closed status.
Assuming, tickets moved to closed status, providing below query. If the your considering other status , then replace status name in the query.
status changed BY currentUser() TO CLOSED AFTER startOfMonth(-1) BEFORE endOfMonth(-1)
Hi @Sreenivasaraju P thanks for your feedback. I mean tickets moved to done status from April 1st 2022 to April 30th 2022.
This query will give all the tickets moved to done between given date range.
status changed TO DONE DURING ("2022/04/01","2022/04/30")
This will give the tickets, which moved by you only, in the given date range
status changed TO DONE BY CURRENTUSER() DURING ("2022/04/01","2022/04/30")
Thank you!
It looks like you're new here. Sign in or register to get started.
