invantive documentation
Invantive Support ForumsLog In / Sign Up

trace: Odoo itgen_odoo_trace

read only per partition

  • Catalog: Odoo
  • Schema: mailing
  • Label: itgen_odoo_trace

Mailing Statistics

Can only retrieve data.

Summary

Improve statistics model to add SMS support. Main attributes of statistics model are used, only some specific data is required.

Table Columns

The columns of the table trace 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
campaign_id varchar2
campaign_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
display_name varchar2 Display Name
email varchar2 Email Normalized email address
failure_type varchar2 Failure type
id int32 ID
links_click_datetime datetime Clicked On Stores last click datetime in case of multi clicks.
links_click_ids varchar2
mail_mail_id varchar2
mail_mail_id_int int32 Mail ID (tech) ID of the related mail_mail. This field is an integer field because the related mail_mail can be deleted separately from its statistics. However the ID is needed for several action and controllers.
mail_mail_id_label varchar2
marketing_trace_id varchar2
marketing_trace_id_label varchar2
mass_mailing_id varchar2
mass_mailing_id_label varchar2
medium_id varchar2 UTM Medium: delivery method (email, sms, ...)
medium_id_label varchar2 UTM Medium: delivery method (email, sms, ...)
message_id varchar2 Message-ID
model varchar2 Document model
open_datetime datetime Opened On
reply_datetime datetime Replied On
res_id int32 Document ID
sent_datetime datetime Sent On
sms_code varchar2 Code
sms_number varchar2 Number
sms_sms_id varchar2
sms_sms_id_int int32 SMS ID (tech)
sms_sms_id_label varchar2
source_id varchar2
source_id_label varchar2
trace_status varchar2 Status
trace_type varchar2 Type
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: