invantive documentation
Invantive Support ForumsLog In / Sign Up

message: Odoo itgen_odoo_message

read only per partition

  • Catalog: Odoo
  • Schema: mail
  • Label: itgen_odoo_message

Message

Can only retrieve data.

Summary

Override MailMessage class in order to add a new type: SMS messages. Those messages comes with their own notification method, using SMS gateway.

Table Columns

The columns of the table message are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
attachment_ids varchar2
author_avatar varbinary Author's avatar
author_guest_id varchar2
author_guest_id_label varchar2
author_id varchar2 Author of the message. If not set, email_from may hold an email address that did not match any partner.
author_id_label varchar2 Author of the message. If not set, email_from may hold an email address that did not match any partner.
body varchar2 Contents
canned_response_ids varchar2
child_ids varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
date datetime Date
description varchar2 Short description Message description: either the subject, or the beginning of the body
display_name varchar2 Display Name
email_add_signature boolean Email Add Signature
email_from varchar2 From Email address of the sender. This field is set when no matching partner is found and replaces the author_id field in the chatter.
email_layout_xmlid varchar2 Layout
has_error boolean Has error
has_sms_error boolean Has SMS error
id int32 ID
is_current_user_or_guest_author boolean Is Current User Or Guest Author
is_internal boolean Employee Only Hide to public / portal users, independently from subtype configuration.
letter_ids varchar2
link_preview_ids varchar2
mail_activity_type_id varchar2
mail_activity_type_id_label varchar2
mail_ids varchar2
mail_server_id varchar2
mail_server_id_label varchar2
message_id varchar2 Message-Id Message unique identifier
message_type varchar2 Type Message type: email for email message, notification for system message, comment for other messages such as user replies
model varchar2 Related Document Model
needaction boolean Need Action
notification_ids varchar2
notified_partner_ids varchar2
parent_id varchar2
parent_id_label varchar2
partner_ids varchar2
preview varchar2 Preview The text-only beginning of the body used as email preview.
rating_ids varchar2
rating_value numeric Rating Value
reaction_ids varchar2
record_name varchar2 Message Record Name
reply_to varchar2 Reply-To Reply email address. Setting the reply_to bypasses the automatic thread creation.
reply_to_force_new boolean No threading for answers If true, answers do not go in the original document discussion thread. Instead, it will check for the reply_to in tracking message-id and redirected accordingly. This has an impact on the generated message-id.
res_id int32 Related Document ID
snailmail_error boolean Snailmail message in error
starred boolean Starred Current user has a starred notification linked to this message
starred_partner_ids varchar2
subject varchar2 Subject
subtype_id varchar2
subtype_id_label varchar2
tracking_value_ids varchar2 Tracked values are stored in a separate model. This field allow to reconstruct the tracking and to generate statistics on the model.
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: