[rt-users] Search for tickets a user has updated in a given time period

Loïc Cadoret lcadoret at keyyo.com
Tue May 19 06:04:00 EDT 2015


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
Keyyo

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.
>
>
> Later,
>
> Andy Law
>
>



More information about the rt-users mailing list