[rt-users] Automatically set ticket to stalled

[Roy El-Hames]

I'll be implementing something very similar soon and my line of thinking 
was an hourly script with:
$RT::Handle->SimpleQuery("update Tickets set status = 'stalled' where 
status ='open' and LastUpdated < (now() - interval 12 hour)");
??
Roy

Mathew Snyder wrote:
> has anyone written a scrip or script that will automatically set a
> ticket to stalled after a certain period of inactivity?
>
> Mathew Snyder
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>