[rt-users] I forgot how to do this

[Mathew]

I'm sure I don't have to explain that sometimes people do things that
require this kind of information.  It's hard to look at the RT interface
and telepathically move the information in the custom field to the
application I'll be using it in.

That said, as the API has the functionality to do this without direct
queries to the database, I have no interest in doing things outside of
said API.  I'd rather not have to include more perl modules than
necessary (DBI) to get information that is already available via modules
I'm already using (everything in RT).

Thanks for the input though.

Mathew
Keep up with my goings on at http://theillien.blogspot.com

James Moseley 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                                                 
>              <theillien at yahoo.                                             
>              com>                                                       To 
>              Sent by:                  RT Users                            
>              rt-users-bounces@         <rt-users at 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: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
> 
> 
>