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

Joop jvdwege at xs4all.nl
Sat May 16 08:24:36 EDT 2015

On 15-5-2015 11:58, LAW Andy wrote:
> 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.
There is a __CurrentUser__ variable that you can use which depends on
who is logged in.
> 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”.
Should work both in 4.0.x as in 4.2.x.
Since I'm not a native english speaker I don't fully understand the
question. Could you elaborate with an example from the search box or
pseudo sql?



More information about the rt-users mailing list