invantive documentation
Invantive Support ForumsLog In / Sign Up

report_channel: Odoo itgen_odoo_report_channel

read only per partition

  • Catalog: Odoo
  • Schema: im_livechat
  • Label: itgen_odoo_report_channel

Livechat Support Channel Report

Can only retrieve data.

Summary

Livechat Support Report on the Channels

Table Columns

The columns of the table report_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
channel_id varchar2
channel_id_label varchar2
channel_name varchar2 Channel Name
country_id varchar2
country_id_label varchar2
day_number varchar2 Day Number 1 is Monday, 7 is Sunday
days_of_activity int32 Days of activity Number of days since the first session of the operator
display_name varchar2 Display Name
duration numeric Average duration Duration of the conversation (in seconds)
id int32 ID
is_anonymous int32 Is visitor anonymous
is_happy int32 Visitor is Happy
is_unrated int32 Session not rated
is_without_answer int32 Session(s) without answer A session is without answer if the operator did not answer. If the visitor is also the operator, the session will always be answered.
livechat_channel_id varchar2
livechat_channel_id_label varchar2
nbr_message int32 Average message Number of message in the conversation
nbr_speaker int32 # of speakers Number of different speakers
partner_id varchar2
partner_id_label varchar2
rating int32 Rating
rating_text varchar2 Satisfaction Rate
start_date datetime Start Date of session
start_date_hour varchar2 Hour of start Date of session
start_hour varchar2 Start Hour of session
technical_name varchar2 Code
time_to_answer numeric Time to answer (sec) Average time in seconds to give the first answer to the visitor
uuid varchar2 UUID

Release Notes

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