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?
Regards, Joop
