RT db schema

alberto.villanueva · April 30, 2009, 1:29pm

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

Ruslan_Zakirov · April 30, 2009, 1:33pm

There is no “records” table in RT’s DB.On Thu, Apr 30, 2009 at 5:29 PM, Alberto Villanueva alberto.villanueva@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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.

alberto.villanueva · April 30, 2009, 1:46pm

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

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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly
Media.

Raed_El-Hames · April 30, 2009, 2:05pm

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:

alberto.villanueva · April 30, 2009, 2:44pm

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

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 ?

It’s possible I haven’t explained correctly I want to do. Sorry

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 developing a perl script to do them

Regards;
Roy

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

Ruslan_Zakirov · April 30, 2009, 4:38pm

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 developing a perl script to do them

Then stop asking meaningless questions and show us example of what you
want to get and which variables do you have (queue name, CF name or
id, or something else). Most users don’t know DB layout, others who
know wouldn’t bother to describe everything to you. Pick a report you
want to get, describe and may be somebody will write you a SQL query.

Also, you can get examples of queries out of RT, enable statements
logging, search using query builder and look into logs. Use Charts and
look into logs.

Regards;
Roy

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

Best regards, Ruslan.