# thread_phone Phone Blacklist Mixin * compute a sanitized phone number based on ´´_sms_get_number_fields´´. It takes first sanitized value, trying each field returned by the method (see ``MailThread._sms_get_number_fields()´´ for more details about the usage of this method); * compute blacklist state of records. It is based on phone.blacklist model and give an easy-to-use field and API to manipulate blacklisted records; Main API methods * ``_phone_set_blacklisted``: set recordset as blacklisted; * ``_phone_reset_blacklisted``: reactivate recordset (even if not blacklisted this method can be called safely); ## Documentation Purpose of this mixin is to offer two services - Catalog: `Odoo` - Schema: `mail` The data in this table is partitioned per value of the column. This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API. ## Table Columns The columns of the table `thread_phone` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `has_message` | `boolean` | Has Message | ☐ | | | `message_attachment_count` | `int32` | Attachment Count | ☐ | | | `message_follower_ids` | `string` | | ☐ | | | `message_has_error_counter` | `int32` | Number of errors | ☐ | Number of messages with delivery error | | `message_has_error` | `boolean` | Message Delivery error | ☐ | If checked, some messages have a delivery error. | | `message_has_sms_error` | `boolean` | SMS Delivery error | ☐ | If checked, some messages have a delivery error. | | `message_ids` | `string` | | ☐ | | | `message_is_follower` | `boolean` | Is Follower | ☐ | | | `message_main_attachment_id_label` | `string` | | ☐ | | | `message_main_attachment_id` | `string` | | ☐ | | | `message_needaction_counter` | `int32` | Number of Actions | ☐ | Number of messages which requires an action | | `message_needaction` | `boolean` | Action Needed | ☐ | If checked, new messages require your attention. | | `message_partner_ids` | `string` | | ☐ | | | `mobile_blacklisted` | `boolean` | Blacklisted Phone Is Mobile | ☐ | Indicates if a blacklisted sanitized phone number is a mobile number. Helps distinguish which number is blacklisted when there is both a mobile and phone field in a model. | | `phone_blacklisted` | `boolean` | Blacklisted Phone is Phone | ☐ | Indicates if a blacklisted sanitized phone number is a phone number. Helps distinguish which number is blacklisted when there is both a mobile and phone field in a model. | | `phone_mobile_search` | `string` | Phone/Mobile | ☐ | | | `phone_sanitized_blacklisted` | `boolean` | Phone Blacklisted | ☐ | If the sanitized phone number is on the blacklist, the contact won't receive mass mailing sms anymore, from any list | | `phone_sanitized` | `string` | Sanitized Number | ☐ | Field used to store sanitized phone number. Helps speeding up searches and comparisons. | | `website_message_ids` | `string` | | ☐ | Website communication history |