DBI is already installed. RT requires it. I just want to avoid having to use it instead of keeping everything within the RT API.
Keep up with me and what I'm up to: http://theillien.blogspot.com James Moseley wrote: > The easiest thing to do would be to write a simple perl script using a DB > perl module, such as DBI, to query to the database using the syntax > provided by Forrest yesterday: > > SELECT DISTINCT CustomFieldValues.Name FROM CustomFieldValues JOIN > CustomFields ON CustomFields.id=CustomFieldValues.CustomField WHERE > CustomField.Name='YourCustomField' > > I beleive you stated yesterday you wanted to avoid installing a perl module > to do this, only wanted to use the API, etc. However, getting this info > via direct SQL query seems to be the most straightforward approach to me. > > Unfortunatley, I am not familiar with the API, so I can't help you there. > > > James Moseley > > > > > > Mathew Snyder > <[EMAIL PROTECTED] > com> To > James Moseley > 08/09/2007 12:27 <[EMAIL PROTECTED]> > PM cc > RT Users > <rt-users@lists.bestpractical.com> > Subject > Re: [rt-users] I forgot how to do > this > > > > > > > > > > > I need an outside script to provide the details so I can feed them into > another > application. > > Keep up with me and what I'm up to: http://theillien.blogspot.com > > > James Moseley wrote: >> Matthew, what are you trying to accomplish? Are you trying to come up > with >> a RT scrip to get these values from within RT, or do you simply need an >> outside script to provide these details? >> >> >> James Moseley >> >> >> >> >> > >> Mathew Snyder > >> <[EMAIL PROTECTED] > >> com> > To >> Sent by: RT Users > >> rt-users-bounces@ <rt-users@lists.bestpractical.com> > >> lists.bestpractic > cc >> al.com > > Subject >> Re: [rt-users] I forgot how to do > >> 08/09/2007 12:16 this > >> PM > > > > > > >> >> >> >> Mathew Snyder wrote: >>> I need to get a list of all of the values for one particular custom >> field. I >>> had a script which did this after about a week or two of banging my head >> against >>> my desk. However, I no longer have this script and am left banging my >> head >>> again as I've forgotten how to gather this list up. >>> >>> I've tried using CustomFieldValue, CustomFieldValues, CustomField and >>> CustomFields. I can't for the life of me figure out how to do this. > Can >>> someone point me in the right direction? >>> >> Can anyone help with this? I've exhausted all of the ideas I've come up >> with to >> sort it out. >> >> Mathew >> _______________________________________________ >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >> >> Community help: http://wiki.bestpractical.com >> Commercial support: [EMAIL PROTECTED] >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> >> >> > > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com