[rt-devel] where does rt3 store the body of the ticket

[Ruslan U. Zakirov]

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:

>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 at internetx.de on 21.08.2003
>
>
>_______________________________________________
>rt-devel mailing list
>rt-devel at lists.fsck.com
>http://lists.fsck.com/mailman/listinfo/rt-devel
>  
>