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_ |
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_ |
boolean |
Has Message | |||
is_ |
boolean |
Blacklist | If the email address is on the blacklist, the contact won't receive mass mailing anymore, from any list | ||
message_ |
int32 |
Attachment Count | |||
message_ |
int32 |
Bounce | Counter of the number of bounced emails for this contact | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: