[rt-users] I forgot how to do this

[James Moseley]

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
>
>
>