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

Ben Goodwin ben at atomicmatrix.net
Thu Oct 30 14:10:54 EST 2003


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

I wrote a CLI script to help.  Here's the relevant script snippet:

$tickets->LimitTransactionDate(OPERATOR => '>', VALUE => '2003-10-01');

while (my $Ticket = $tickets->Next) {
        print $Ticket->id . "\n";
}


And the resulting queries:

SELECT  * FROM Users WHERE Name = 'RT_System'
SELECT  * FROM Users WHERE Name = 'Nobody'
SELECT  * FROM Queues WHERE Name = 'Incoming'
SELECT DISTINCT main.* FROM Tickets main, Transactions Transactions_1,
Attachments Attachments_2  WHERE ((main.EffectiveId = main.id)) AND
((main.Type = 'ticket')) AND ( (  ( (Attachments_2.Created > '2003-10-30
19:05:04') )  ) )  AND Attachments_2.TransactionId = Transactions_1.id AND
main.id = Transactions_1.Ticket

I've noticed that the Attachments_2.Created > 'XXX' has a date in XXX
that's always NOW() ... In fact it's NOW() for the "<" operator as well.

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

0.93_3 caused Can't call method "quote" on an undefined value for a
dbh->quote call.. I don't have the precise message anymore but I can
reinstall it and get it to you if you need.  It always happened so I
figured it would be easily reproduceable.
I also noticed that 0.92 caused the list of tickets I own to change
order.. to an order I couldn't figure out.

  -=| Ben





More information about the rt-users mailing list