3 use RT::Test tests => 5;
5 use RT::Report::Tickets;
7 my $ticket = RT::Test->create_ticket( Queue => 'General', Subject => 'test' );
9 my $tickets = RT::Report::Tickets->new( RT->SystemUser );
10 $tickets->FromSQL('Updated <= "tomorrow"');
11 is( $tickets->Count, 1, "search with transaction join and positive results" );
13 $tickets->FromSQL('Updated < "yesterday"');
14 is( $tickets->Count, 0, "search with transaction join and 0 results" );