[rt-users] Searching on TransactionDate > xxx = no results

[Jesse Vincent]

On Thu, Oct 30, 2003 at 12:49:44PM -0600, Ben Goodwin wrote:
> Ever since I upgraded from RT2 to RT3, a search like:
> 
> TransactionDate > 2003-10-01 04:00:00 GMT
> 
> *always* fails to return anything.  Searching for TransactionDate < xxx
> does return stuff though.
> 
> I've tried to debug this but I haven't had much luck.  It's hard to grok
> the stuff in the mysql SQL log especially with all the high-ascii chars in
> the session table.

less and/or grep are your friends. We really need to see the SELECT
that's searching the Tickets table.

> I've tested on production and in development.  Both RH7.3 systems... I've
> even tried moving to a self-compiled Perl 5.8.1  since 7.3 comes with
> 5.6.1.  The dev environment has all the latest perl modules (as of a
> couple hours ago) except searchbuilder which is at 0.88 cuz the newer
> versions appear to have issues.

I'm not sure what you're talking about. What issues are you referring
to?

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.