[rt-users] Change ticket status when pass due date

[Kevin Falcone]

On Wed, Feb 15, 2012 at 05:34:28PM +0100, Daniel Garcia Mejia wrote:
> I was searching about this theme  and I read that at now there is no
> exist any script that check for any ticket that have passed the due
> date and ,later, put the ticket in 'stalled'.
> I have read that it would be possible with rt-croontol, but that
> would have to search all open tickets, new ,etc ... and if that were
> true, if our database has a large volume of tickets would be very
> inefficient not?
> 
> What module would be used in rt-croontol to search for these tickets?
> There is some example?

If you're running into actual performance issues with rt-crontool,
please show the TicketSQL being used and the SQL generated along with
an explain plan.

rt-crontool is going to take the same syntax as you can build from the
Query Builder, so if you can build an inefficient date query there,
you can easily test and add indexes to your database.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120215/9d671697/attachment.sig>