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