[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