Filter tickets by "LastUpdated" field

Hey everybody,

I need to run a search of new, open or stalled tickets from last month. I’m running a search taking March as reference (last month) with the following parameters:

Status = ‘new’ AND Status = ‘open’ AND Status = ‘stalled’ AND LastUpdated = ‘2020-03-01’ AND LastUpdated = ‘2020-03-31’

But I get 0 results. As far as I can see, ‘LastUpdated’ field is not possible to run search between date ranges.

Is it possible to run a search like mine?

Many thanks in advance!

Best regards

You are using AND where you should be using OR

Status = ‘new’ OR Status = ‘open’ OR Status = ‘stalled’

Then for your dates you aren’t searching a date range you’re looking for LastUpdated equaling two dates which isn’t possible. You should be able to do something like LastUpdated > '1 month ago'

Also depending on your version of RT you may be able to use Status = '__Active__' which will account for all those statuses

Hey Knation,

Many thanks for your reply! :slight_smile:

Best regards