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_ |
varchar2 |
||||
channel_ |
varchar2 |
||||
channel_ |
varchar2 |
Channel Name | |||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
day_ |
varchar2 |
Day Number | 1 is Monday, 7 is Sunday | ||
days_ |
int32 |
Days of activity | Number of days since the first session of the operator | ||
display_ |
varchar2 |
Display Name | |||
duration |
numeric |
Average duration | Duration of the conversation (in seconds) | ||
id |
int32 |
ID | |||
is_ |
int32 |
Is visitor anonymous | |||
is_ |
int32 |
Visitor is Happy | |||
is_ |
int32 |
Session not rated | |||
is_ |
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_ |
varchar2 |
||||
livechat_ |
varchar2 |
||||
nbr_ |
int32 |
Average message | Number of message in the conversation | ||
nbr_ |
int32 |
# of speakers | Number of different speakers | ||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
rating |
int32 |
Rating | |||
rating_ |
varchar2 |
Satisfaction Rate | |||
start_ |
datetime |
Start Date of session | |||
start_ |
varchar2 |
Hour of start Date of session | |||
start_ |
varchar2 |
Start Hour of session | |||
technical_ |
varchar2 |
Code | |||
time_ |
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: