[rt-users] Change text in tickts using database

[Juanjo]

Thanks.

But i don´t see the email content, only see the headers.

I´m looking to change the content of the messages.

I see in the attachments tab, a column called content, but says (trough
phpMyAdmin) Binary Not Edit!!

Regards.


2012/10/18 Tim Cutts <tjrc at sanger.ac.uk>

>
> On 18 Oct 2012, at 15:58, Juanjo <juanjillo at gmail.com> 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??
>
> The Attachments table contains most of it.
>
> Each ticket in the Tickets table has one or more transactions in the
> Transactions table, and each transaction can have zero or more attachments
> in the Attachments table, depending on the kind of transaction.
>
> Tim
>
> --
>  The Wellcome Trust Sanger Institute is operated by Genome Research
>  Limited, a charity registered in England with number 1021457 and a
>  company registered in England with number 2742969, whose registered
>  office is 215 Euston Road, London, NW1 2BE.
>



-- 
Un saludo.
Juanjo Corral
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121019/195db90d/attachment.htm>