that is exactly what I was looking for, thanks a lot David ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of David Salgado Vidal Sent: 02 May 2007 11:01 To: User questions and discussions about OTRS.org Subject: RE: [otrs] Hi People Sorry, i didn't explain it correctly. I understood that you want to consult the e-mail's body, so I ask you if you have looked for it in the article table. I hope it helps you. Regards. ________________________________ De: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] En nombre de Arnold, Andrew Enviado el: miércoles, 02 de mayo de 2007 11:42 Para: User questions and discussions about OTRS.org Asunto: RE: [otrs] Hi People sorry, what are you asking? tks ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of David Salgado Vidal Sent: 30 April 2007 17:34 To: User questions and discussions about OTRS.org Subject: RE: [otrs] Hi People Have you find in the article table? ________________________________ De: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] En nombre de Arnold, Andrew Enviado el: lunes, 30 de abril de 2007 18:21 Para: User questions and discussions about OTRS.org Asunto: FW: [otrs] Hi People Any news on this anyone. Thanks ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Arnold, Andrew Sent: 05 March 2007 13:27 To: User questions and discussions about OTRS.org Subject: [otrs] Hi People I am trying to find out where I can report on info stored in OTRS. I have found the subject heading of a ticket in the MySql DB. (this is in the `title` field in the `ticket` table.) Where can i find the actual e-mail text - the body of the e-mail pls. I have looked at a few ways of getting this info out but cannot find a suitable way of doing it. Anyone please help as I need to have the reporting sorted ASAP. Tks Andrew Arnold IT Support Analyst mailto:andrew.arnold@hammondsdirect.com This message is confidential and may be legally privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system; you must not copy or disclose the contents of this message or any attachment to any other person. Copyright in documents created by or on behalf of this firm remains vested in the firm, and we assert our moral rights, unless the terms of our relevant client's engagement provide otherwise. HammondsDirect is regulated in the United Kingdom by the Law Society. The partners in the firm are either solicitors or registered foreign lawyers and a list of their names and professional qualifications can be inspected at Pennine House, Well Street, Bradford, BD1 5NU. This e-mail has been scanned for all viruses on behalf of HammondsDirect by Integralis e:scan. This message is confidential and may be legally privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system; you must not copy or disclose the contents of this message or any attachment to any other person. Copyright in documents created by or on behalf of this firm remains vested in the firm, and we assert our moral rights, unless the terms of our relevant client's engagement provide otherwise. HammondsDirect is regulated in the United Kingdom by the Law Society. The partners in the firm are either solicitors or registered foreign lawyers and a list of their names and professional qualifications can be inspected at Pennine House, Well Street, Bradford, BD1 5NU. This e-mail has been scanned for all viruses on behalf of HammondsDirect by Integralis e:scan. This message is confidential and may be legally privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system; you must not copy or disclose the contents of this message or any attachment to any other person. Copyright in documents created by or on behalf of this firm remains vested in the firm, and we assert our moral rights, unless the terms of our relevant client's engagement provide otherwise. HammondsDirect is regulated in the United Kingdom by the Law Society. The partners in the firm are either solicitors or registered foreign lawyers and a list of their names and professional qualifications can be inspected at Pennine House, Well Street, Bradford, BD1 5NU. This e-mail has been scanned for all viruses on behalf of HammondsDirect by Integralis e:scan.