[rt-users] Database help

[Aaron Guise]

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
aaron at guise.net.nz
 *



On Thu, Apr 2, 2009 at 11:13 AM, Ken Crocker <kfcrocker at lbl.gov> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090405/36468738/attachment.htm>