That the thing. I've done it before. I just don't have the code I used so I don't have anything to look at. Although, I may have simply pulled down *all* of the custom field values and told the script to skip those from custom fields I wasn't looking for.
Keep up with me and what I'm up to: http://theillien.blogspot.com Roy El-Hames wrote: > Matthew; > > If you want (needed urgent) you can get your data using dbi and query > the tables directly, the queries you need: > select o.content from ObjectCustomFieldValues o left join CustomFields c > on o.CustomField = c.id where c.Name = 'Environment'; > > I don't **think** there is a way within the RT methods to grab all > values for a particular CF, from what I've seen it'll expect a ticket id > (ie pull the value for one ticket) ..but I might be wrong .. if you are > desperate use dbi as I mentioned above. > > Regards; > Roy > > > Mathew Snyder wrote: >> 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 >> >> > > _______________________________________________ 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