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 protected] [mailto:[email protected]] On Behalf Of Jonathan Rummel Sent: 22 June 2010 3:35 PM To: [email protected] 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? Thanks! Jonathan 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 http://www.netintelligence.com/email 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. **************************************************************************** Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
