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

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@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jonathan Rummel
Sent: 22 June 2010 3:35 PM
To: rt-users@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?

Thanks!
Jonathan

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
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.

Jonathan,

What’s wrong with using the “Starts” and “Due” date fields in the ticket? It
seems to me they are the same thing you are looking to do with those Custom
Fields.

Kenn
LBNLOn Tue, Jun 22, 2010 at 7:34 AM, Jonathan Rummel jrummel@imapp.com wrote:

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