[rt-users] Open stalled ticket (timed)

[rt-users]

Hi,

>-----Original Message-----
>From: Lynoure Rajamäki [mailto:lynoure at otaverkko.fi] 
>Posted At: Friday, December 20, 2002 2:51 PM

>Requestor wants thing X to be done two weeks from today (and 
>not earlier). Owner stalls the ticket for those two weeks. 
>After that time RT reopens the ticket.
>
>This would keeps these tickets from being either confusing 
>(open tickets that just keep staying unresolved) or in danger 
>of being forgotten (stalled tickets).
>
>Does the feature exist already? If not, does anybody have any 
>ideas how I could go about implementing it?

we just use another box on the startpage for Tickets, that are stalled, but have reached their "Starts" Date. Copy MyTickets and change the INIT part to somesthing like this:

my $MyTickets;
$MyTickets = new RT::Tickets ($session{'CurrentUser'});
$MyTickets->LimitOwner(VALUE => $session{'CurrentUser'}->Id);
$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(-100);
my $Add = $session{'CurrentUser'}->UserObj->RemindStarts*3600;
$EndDate->AddSeconds(+$Add);

$MyTickets->LimitDate(FIELD => 'Starts', OPERATOR => '<', VALUE => $EndDate->ISO);
$MyTickets->LimitDate(FIELD => 'Starts', OPERATOR => '>', VALUE => $StartDate->ISO);

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