Hi all,
How can I get a list of tickets that were handled this week?
By "handled" I mean updated by someone from the service-desk team.
In other words, I would like to do a filter like:
updatedBy in (John, Bob, Chris) between (2019-05-05,2019-05-11)
My problem is that while updatedBy works fine and updated>= works fine, I do not know how to have them work together.
If the ticket was updated a month ago by a member of the team and yesterday by the customer, I do not want it to be in the result list.
I want to get in the result list only the tickets that were updated by the team members during the last week.
Any suggestion?
Thanks
Hi Jack,
Thanks for the answer, but my concern is that as far as I know, using updatedby AND updateddate, gives more results than what I want.
For example, if the ticket123 has been updated by X one month ago and also updated by Y yesterday, a query "updatedby X AND updateddate=yesterday" will give me the ticket123, which is not what I want.
I would like to be able to write a condition like updatedBY_atDate=(X,yesterday) so that a ticket that was updated by X a month ago and by Y yesterday will not show, but only tickets updated by X yesterday will show.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.