invantive documentation
Invantive Support ForumsLog In / Sign Up

channel: Odoo itgen_odoo_channel

read only per partition

  • Catalog: Odoo
  • Schema: mail
  • Label: itgen_odoo_channel

Discussion Channel

Can only retrieve data.

Summary

Chat Session Reprensenting a conversation between users. It extends the base method for anonymous usage.

Table Columns

The columns of the table channel 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
active boolean Active Set active to false to hide the channel without removing it.
anonymous_name varchar2 Anonymous Name
avatar_128 varbinary Avatar
channel_member_ids varchar2
channel_partner_ids varchar2
channel_type varchar2 Channel Type Chat is private and unique between 2 persons. Group is private among invited persons. Channel can be freely joined (depending on its configuration).
chatbot_current_step_id varchar2
chatbot_current_step_id_label varchar2
chatbot_message_ids varchar2
country_id varchar2 Country of the visitor of the channel
country_id_label varchar2 Country of the visitor of the channel
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
default_display_mode varchar2 Default Display Mode Determines how the channel will be displayed by default when opening it from its invitation link. No value means display text (no voice/video).
description varchar2 Description
display_name varchar2 Display Name
group_ids varchar2 Members of those groups will automatically added as followers. Note that they will be able to manage their subscription manually if necessary.
group_public_id varchar2
group_public_id_label varchar2
has_message boolean Has Message
id int32 ID
image_128 varbinary Image
invitation_url varchar2 Invitation URL
is_chat boolean Is a chat
is_member boolean Is Member
livechat_active boolean Is livechat ongoing? Livechat session is active until visitor leaves the conversation.
livechat_channel_id varchar2
livechat_channel_id_label varchar2
livechat_operator_id varchar2
livechat_operator_id_label varchar2
livechat_visitor_id varchar2
livechat_visitor_id_label varchar2
member_count int32 Member Count
message_attachment_count int32 Attachment Count
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
name varchar2 Name
rating_avg numeric Average Rating
rating_avg_text varchar2 Rating Avg Text
rating_count int32 Rating count
rating_ids varchar2
rating_last_feedback varchar2 Rating Last Feedback
rating_last_image varbinary Rating Last Image
rating_last_text varchar2 Rating Text
rating_last_value numeric Rating Last Value
rating_percentage_satisfaction numeric Rating Satisfaction
rtc_session_ids varchar2
subscription_department_ids varchar2 Automatically subscribe members of those departments to the channel.
uuid varchar2 UUID
website_message_ids varchar2 Website communication history
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: