Making a search (Open tickets one week ago)


#1

Hi everybody!

I want to make a search of all open tickets (created) one week ago. That search must take, as reference, the first day as the current day. So, for instance, if I run the search on 09/08, the search must mark 09/01 as the first day and 09/08 as the last day.

I assume this must be done using SQL Query builder, but I am a bit unfamiliar with it.

Can please someone help me out with this?

Thanks in advance!

Best regards


#2

Use string “1 week ago” as date in “Created” search criteria.

RT uses those modules to parse dates:

Time::ParseDate
DateTime::Format::Natural

looking at those modules documentations on cpan, you’ll find allowed search strings.


#3

Hey,

Thanks for the tip!

Best regards