[rt-users] I forgot how to do this

[Mathew Snyder]

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