LimitDue works good, but LimitStarts not

Hi,

with the help of Bruce, i figured out, how to use LimitDate, to display all tickets, with exceeded due date on the start page. In the init statement, i use the the following code and it works perfect:

my $MyTickets;
$MyTickets = new RT::Tickets ($session{‘CurrentUser’});
$MyTickets->LimitStatus(VALUE => “open”);
$MyTickets->LimitStatus(VALUE => “new”);
$MyTickets->LimitStatus(VALUE => “stalled”);

my $StartDate = new RT::Date ($session{‘CurrentUser’});
my $EndDate = new RT::Date ($session{‘CurrentUser’});
$StartDate->SetToNow();
$EndDate->SetToNow();
$StartDate->AddDays(-10);
$EndDate->AddSeconds(+7200);

$MyTickets->LimitDate(FIELD => ‘Due’, OPERATOR => ‘<’, VALUE => $EndDate->ISO);
$MyTickets->LimitDate(FIELD => ‘Due’, OPERATOR => ‘>’, VALUE => $StartDate->ISO);

$MyTickets->OrderBy(FIELD => ‘Priority’, ORDER => ‘ASC’);
$MyTickets->RowsPerPage(50);

But when i want to limit on the starts date, it displays just all tickets:

$MyTickets->LimitDate(FIELD => ‘Starts’, OPERATOR => ‘<’, VALUE => $EndDate->ISO);
or
$MyTickets->LimitStarts(OPERATOR => ‘<’, VALUE => $EndDate->ISO);

I tried the same searches in the web ui, which do not work either. Does anybody have an idea? Is limiting on the starts field broken?

Thanks, Julian

Julian Hein NETWAYS GmbH
Managing Director Deutschherrnstr. 47a
Fon.0911/92885-0 D-90429 Nürnberg
Fax.0911/92885-31
jhein@netways.de www.netways.de

But when i want to limit on the starts date, it displays just all tickets:

$MyTickets->LimitDate(FIELD => ‘Starts’, OPERATOR => ‘<’, VALUE => $EndDate->ISO);
or
$MyTickets->LimitStarts(OPERATOR => ‘<’, VALUE => $EndDate->ISO);

Ich got bitten by this before. It is (from memory) a problem in the
default ENTRYAGGREGATOR keyword, which defaults to ‘OR’. A construct like
the following should help (change fields as appropriate

Anything due before our EndDate

$MyTickets->LimitDate(FIELD => ‘Due’,
OPERATOR => ‘<’,
VALUE => $EndDate->ISO
ENTRYAGGREGATOR => ‘AND’ );

AND, anything due after our StartDate

$MyTickets->LimitDate(FIELD => ‘Due’,
OPERATOR => ‘>’,
VALUE => $StartDate->ISO
ENTRYAGGREGATOR => ‘AND’ );

Regards,

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B                      Operations