[rt-devel] LimitDue works good, but LimitStarts not
rt-devel
rt-devel at lists.netways.de
Tue May 7 17:21:59 EDT 2002
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 at netways.de www.netways.de
More information about the Rt-devel
mailing list