Why do you need a query to do this? Can't you just look at Configuration-> CustomFields->YourCustomField and view its current value options?
If you need to do a SQL query, use: SELECT DISTINCT CustomFieldValues.Name FROM CustomFieldValues JOIN CustomFields ON CustomFields.id=CustomFieldValues.CustomField WHERE CustomField.Name='YourCustomField' AND CustomFieldValues.Disabled=0; If you want ALL customfieldvalues for the field (and not just the current ones) get rid of the Disabled specification. Forrest On 8/8/07, James Moseley <[EMAIL PROTECTED]> wrote: > > I am sure you can do this by using a single mysql command, but... > > To get the numeric id of the custom field: > > mysql> select id from CustomFields where Name='<custom field name>'; > > Grab the id, then: > > mysql> select * from CustomFieldValues where CustomField='<id>'; > > 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 > [rt-users] I forgot how to do this > 08/08/2007 02:40 > PM > > > > > > > > > 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? > > -- > Keep up with me and what I'm up to: http://theillien.blogspot.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 >
_______________________________________________ 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