News & Updates
Training & Certification
to create and rate content, and to follow, bookmark, and share content with other members.
Where is the email body in the database, instead of message_id?
Question asked by
on May 2, 2014
on May 2, 2014 by Francesca Shiekh
Show 0 Likes
I want email body in database but getting message_id .any help on it?
No one else has this question
Mark as assumed answered
This content has been marked as final.
Show 1 comment
(Required, will not be published)
May 2, 2014 9:19 AM
Are you trying to write a sql query?
The email body is in emails_text.description and/or emails_text.description_html
SELECT description, description_html
FROM emails, emails_text
WHERE emails.id = emails_text.email_id
For 6.5.x Professional the schema for emails is here:
Show 0 Likes
Retrieving data ...
How to add "File Upload" field in Case module in SugarCRM CE 6.5.x version?
File uploads in Custom Module (Document) not working via SOAP api
Is there a way to configure a trigger such that when a new activity (call, meeting, task, note, etc.) is added in relation to another record (i.e. an opportunity record) the Date Modified on the related/parent (opportunity record) changes?
Writable Upload Directory Warning: Not Writable
Doubling Sugar application performance