invantive documentation
Invantive Support ForumsLog In / Sign Up

thread_blacklist: Odoo itgen_odoo_thread_blacklist

read only per partition

  • Catalog: Odoo
  • Schema: mail
  • Label: itgen_odoo_thread_blacklist

Mail Blacklist mixin

Can only retrieve data.

Summary

Mixin that is inherited by all model with opt out. This mixin stores a normalized email based on primary_email field.

A normalized email is considered as :
    - having a left part + @ + a right part (the domain can be without '.something')
    - being lower case
    - having no name before the address. Typically, having no 'Name <>'
Ex:
    - Formatted Email : 'Name <NaMe@DoMaIn.CoM>'
    - Normalized Email : 'name@domain.com'

The primary email field can be specified on the parent model, if it differs from the default one ('email')
The email_normalized field can than be used on that model to search quickly on emails (by simple comparison
and not using time consuming regex anymore).

Using this email_normalized field, blacklist status is computed.

Mail Thread capabilities are required for this mixin.

Table Columns

The columns of the table thread_blacklist 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
email_normalized varchar2 Normalized Email This field is used to search on email address as the primary email field can contain more than strictly an email address.
has_message boolean Has Message
is_blacklisted boolean Blacklist If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list
message_attachment_count int32 Attachment Count
message_bounce int32 Bounce Counter of the number of bounced emails for this contact
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
website_message_ids varchar2 Website communication history

Release Notes

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