On 18/10/2012 15:58, Juanjo wrote:
Hi,
I have to change some test inside the tickets directly on database.
I don´t find where are the comments, or the emails body that we send to
rt or create trought web.
Could you tell me what table and what comun have this data??
It's in the Content field in the Attachments table. This is keyed to the
Transactions table via TransactionId, and the Transactions table in turn
is keyed to the Tickets table via ObjectId.
Note that the Content field in Attachments has a LONGBLOB data type, and
will also contain binary data where relevant (eg, an image attachment).
So be careful when editing it, as you can easily create problems for
yourself! The table has a ContentType field which will tell you what
kind of data is inside Content.
(Disclaimer: the above relates to RT v 3. It may be different for other
versions).
Mark
--
Sent from my Turing-Flowers Colossus
http://mark.goodge.co.uk
--------
Final RT training for 2012 in Atlanta, GA - October 23 & 24
http://bestpractical.com/training
We're hiring! http://bestpractical.com/jobs
