Thanks Ken, That did the trick perfectly. Now I have been able to utilize Perl and MySQL to provide a means of emailing reminders to them when they fall due. I was unable to get the rtremind script from the wiki working and hence have now created my own. Many thanks for pointing me in the right direction, but in hindsight I should have guessed they were n the Tickets table.
*Regards,* *Aaron Guise 027 212 6638 [email protected] * On Thu, Apr 2, 2009 at 11:13 AM, Ken Crocker <[email protected]> wrote: > Tom, > > Reminders ARE tickets. You will find them in the TICKETS table with > Type = 'reminder'. All information that is available at the Ticket level is > there for the reminder (Due Date, Started, Resolved, CreatedBy, Status, > etc.). However, reminders do NOT go away automatically. If I remember > correctly (damn. Should have created a reminder for this one, ;-), you have > to disable them from the originating ticket. Even if the ticket is resolved, > you can go to it and modify it to turn off the reminder. A simple SQL would > suffice for finding reminders on tickets that have been resolved. Hope this > helps. > > > Kenn > LBNL > > On 4/1/2009 2:29 PM, Tom Lahti wrote: > > This is probably a silly question but I just wonder if anyone is aware at > the database level how I would locate a reminder and it's due date? I have > looked about and can't see it for the life of me. > > > Better yet... is there an (as yet undocumented) REST URI for > reading/setting/deleting reminders? > > > > > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [email protected] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
