Search on Resolved date gives open tickets

RT Users
1

Hi

When I do a search for tickets resolved before a certain date I get open and
stalled tickets in the result. I expected only resolved tickets. I use
RT3.0.9. Any ideas??

Thanks,
Danie Marais

2

Danie Marais wrote:

When I do a search for tickets resolved before a certain date I get open and
stalled tickets in the result. I expected only resolved tickets. I use
RT3.0.9. Any ideas??

Were the tickets resolved and then reopened?
�|� Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

3

No they were not. Brand new tickets.

4

Well well,I have discovered that a lot of the tickets in the Tickets table
have a resolved date of 1970-01-01 00:00:00 which might explain the results.

Seems this might have been a result of the Resolved(quiet) patch…

Danie Marais

5

However, OPEN tickets have a resolved date of 1970-01-01 00:00:00. So it
comes up in the Resolved < (date) search.

Well well,I have discovered that a lot of the tickets in the Tickets table
have a resolved date of 1970-01-01 00:00:00 which might explain the
results.