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.zaki...@gmail.com] >> Enviado el: jueves, 30 de abril de 2009 15:33 >> Para: Alberto Villanueva >> CC: rt-users@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.villanu...@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: sa...@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: sa...@bestpractical.com > > > 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: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com