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

Jesse Vincent jesse at bestpractical.com
Thu Oct 30 14:25:27 EST 2003



On Thu, Oct 30, 2003 at 01:10:54PM -0600, Ben Goodwin wrote:
> > 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";
> }
> 
> 
> 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

This is now fsck.com ticket #4075.

	-jesse


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



More information about the rt-users mailing list