Search for tickets a user has updated in a given time period

RT Users
1

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

The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.

2

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

3

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 :