If I understand correctly what you want to do, search for tickets that have been updated between two dates, you should use the Query Builder (something like LastUpdated > '2015-05-16' AND LastUpdated < '2015-05-18' should match your query).

You can play with a large panel of criterias and by using the advanced view, do a lot of things. But be really carefull with your request, according to what you're looking for, you could crash your database due to a too big amount of results.

Hope it helps

Loic Cadoret
IT Technician

Le 15/05/2015 11:58, LAW Andy a écrit :
I may be missing something really obvious, but I can’t work out how to run a 
particular query.

I want to pull out a list of tickets that have been updated at some point in a 
given time period - usually the past two weeks but occasionally over a 
different period - by a specific user. The tickets may or may not be owned by 
that person and they may or may not be the last person to update that ticket. 
Basically, I’m looking for all activity in that time period.

I can see how to run the search for tickets that are *Last* updated by a particular 
user but not ones that have "been updated by”. Am I being stupid?

Can someone please point me in the right direction.

For info, we’re running 4.0.10 and could upgrade if the answer turns out to be 
"you can do this in the latest version”.

Thanks in advance.


Andy Law

Reply via email to