[rt-users] Scheduled tasks based on custom field

Steve Anderson steve.anderson at bipsolutions.com
Tue Jun 22 10:39:44 EDT 2010

If you're using something that can directly access the database, then take a look at something like the sql query below.

select distinct ObjectId,Content from ObjectCustomFieldValues where CustomField=5

Where the CustomField number is the number of the custom start date field (rather than 5)

Steve Anderson

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Jonathan Rummel
Sent: 22 June 2010 3:35 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Scheduled tasks based on custom field

Hi everyone,

I have a queue called 'Research' that I want to have 2 CF's in.  Both CFs
will be an 'enter one value' field.  One called "Start Date" which will get
a date entered into it in XX/XX/XXXX format, and another called "Repeat
every (months)" where the user will just enter in a number for how many
months they want between the ticket's creation.

I plan on making a cron job for the ticket creation, but is there a way for
me to use what is entered into the above CFs to tell the cron job when to
create the appropriate tickets?


RT 3.6.5, MySQL
View this message in context: http://old.nabble.com/Scheduled-tasks-based-on-custom-field-tp28960849p28960849.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.

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

This email has been scanned by Netintelligence

BiP Solutions Limited is a company registered in Scotland with Company
Number SC086146 and VAT number 383030966 and having its registered
office at Medius, 60 Pacific Quay, Glasgow, G51 1DZ.

This e-mail (and any attachment) is intended only for the attention of
the addressee(s). Its unauthorised use, disclosure, storage or copying
is not permitted. If you are not the intended recipient, please destroy
all copies and inform the sender by return e-mail.
This e-mail (whether you are the sender or the recipient) may be
monitored, recorded and retained by BiP Solutions Ltd.
E-mail monitoring/ blocking software may be used, and e-mail content may
be read at any time.You have a responsibility to ensure laws are not
broken when composing or forwarding e-mails and their contents.

More information about the rt-users mailing list