Database help

Hi Everyone,

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.

Regards,

*Aaron Guise
027 212 6638
aaron@guise.net.nz

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?

– ============================
Tom Lahti
BIT Statement LLC

(425)251-0833 x 117
http://www.bitstatement.net/
– ============================

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
LBNLOn 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?

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@guise.net.nzOn Thu, Apr 2, 2009 at 11:13 AM, Ken Crocker kfcrocker@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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com