On Thu, Apr 30, 2009 at 6:44 PM, Alberto Villanueva
wrote:
> Hi!
[snip]
>
> I don't know if it's easier than. I need to do several queries in
> MySQL because the different reports tools for RT don't run all
> queries my Client wants to. So if I get all queries, I'll speak
> to my boss for develo
Hi!
> mysql> desc ObjectCustomFieldValues;
Before, this already did it :-) but I didn't understand
ObjectType.
>
> ObjectId is Tickets.Id if ObjectType = 'RT::Ticket';
> CustomField is CustomFields.Id
I understood it, but within ObjectType = 'RT::Ticket'. I think
this is the most important :
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
>> wrote:
>
: + 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 schem
There is no "records" table in RT's DB.
On Thu, Apr 30, 2009 at 5:29 PM, Alberto Villanueva
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
> ___
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. 2802
