[rt-users] RT db schema

Raed El-Hames rfh at vialtus.com
Thu Apr 30 10:05:52 EDT 2009


mysql>  desc ObjectCustomFieldValues;

ObjectId is Tickets.Id if ObjectType = 'RT::Ticket';
CustomField is CustomFields.Id

I did see your earlier question, though I am not sure what you are 
trying to do, using perl and RT api will make your life much easier ?

Regards;
Roy

Alberto Villanueva wrote:
> Then, how do I link Tickets to CustomFields?? :-( :-(
>
> Thanks a lot!
>
> Best regards,
>
> ALBERTO VILLANUEVA DEL VAL 
> Consultor
> ____________________________________________
> Altran Technologies
> ParqueEmpresarial Las Mercedes, Edificio 1 
> C/ Campezo, 1. 28022 Madrid
> Tel: + 34 91 744 46 00 - Ext: 2205
> Fax: + 34 91 415 24 57
> www.altran.es
>  
>  
>
>   
>> -----Mensaje original-----
>> De: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com] 
>> Enviado el: jueves, 30 de abril de 2009 15:33
>> Para: Alberto Villanueva
>> CC: rt-users at lists.bestpractical.com
>> Asunto: Re: [rt-users] RT db schema
>>
>> There is no "records" table in RT's DB.
>>
>> On Thu, Apr 30, 2009 at 5:29 PM, Alberto Villanueva 
>> <alberto.villanueva at altran.es> wrote:
>>     
>>> Hi,
>>>
>>> Does someone know the "RECORDS" table?? If I write "show
>>>       
> tables"
>   
>>> in MySQL, this table doesn't exist. Any idea??
>>>
>>> Best regards,
>>>
>>> ALBERTO VILLANUEVA DEL VAL
>>> Consultor
>>> ____________________________________________
>>> Altran Technologies
>>> ParqueEmpresarial Las Mercedes, Edificio 1 C/ Campezo, 1. 
>>>       
>> 28022 Madrid
>>     
>>> Tel: + 34 91 744 46 00 - Ext: 2205
>>> Fax: + 34 91 415 24 57
>>> www.altran.es
>>>
>>>
>>> _______________________________________________
>>>
>>>       
> 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
>>>
>>>       
>>
>> -- 
>> Best regards, Ruslan.
>>
>>     
>
> _______________________________________________
> 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
>   



More information about the rt-users mailing list