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: email@example.com [mailto:firstname.lastname@example.org] On Behalf Of Jonathan Rummel
Sent: 22 June 2010 3:35 PM
Subject: [rt-users] Scheduled tasks based on custom field
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
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.