Where does rt3 store the body of the ticket

RT Developers
1

i there,

can anybody tell me, where i can find the body of a ticket
in the database ?? i searched all tables, but only found the
attachments, but never the body of the ticket itself.

thx for any hint.

best regards,
micha
– michab, micha_rt@internetx.de on 21.08.2003

2

select ti.id, a.id, a.ContentType, a.Content from Transactions t,
Attachments a, Tickets ti where ti.id = t.Ticket and a.TransactionId =
t.id and t.Type = ‘Create’ and ti.id = 14255;

this request will give you answer as I think

michab wrote:

3

can anybody tell me, where i can find the body of a ticket
in the database ?? i searched all tables, but only found the
attachments, but never the body of the ticket itself.

Attachments are an illusion :slight_smile:

A mail message can be single-part or multi-part.

A single-part message is stored as
→ an “attachment” with Parent == 0 and a non-NULL content
The content of this attachment is the body.

A multi-part message is stored as
→ a “parent attachment” with Parent == 0 and a NULL content
→ a “sub-attachment” for each part with Parent == id of parent attachment
The sub-attachment with the lowest id stores the body.

Greetings,
,eM"“=. a”-. Michael van Elst
dWWMWM" - :GM==; mlelstv@dev.de.cw.net
:WWMWMw=–. "W=’ cable & wireless
9WWMm==-.
“-Wmw-” CABLE & WIRELESS