ticket_report_analysis: Odoo itgen_odoo_ticket_report_analysis
read only per partition
- Catalog:
Odoo - Schema:
helpdesk - Label: itgen_odoo_ticket_report_analysis
Ticket Analysis
Can only retrieve data.
Table Columns
The columns of the table ticket_report_analysis 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 | |||
assign_ |
datetime |
First assignment date | |||
avg_ |
numeric |
Average Hours to Respond | |||
close_ |
datetime |
Close date | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created On | |||
display_ |
varchar2 |
Display Name | |||
first_ |
numeric |
Hours to First Response | |||
id |
int32 |
ID | |||
kanban_ |
varchar2 |
Kanban State | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
priority |
varchar2 |
Minimum Priority | |||
rating_ |
numeric |
Rating (/5) | |||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
sla_ |
boolean |
Failed SLA Policy | |||
team_ |
varchar2 |
||||
team_ |
varchar2 |
||||
ticket_ |
numeric |
Hours to Assign | |||
ticket_ |
numeric |
Hours to Close | |||
ticket_ |
datetime |
Ticket Deadline | |||
ticket_ |
numeric |
Hours to SLA Deadline | |||
ticket_ |
varchar2 |
||||
ticket_ |
varchar2 |
||||
ticket_ |
numeric |
Hours Open | |||
ticket_ |
varchar2 |
||||
ticket_ |
varchar2 |
||||
ticket_ |
varchar2 |
||||
ticket_ |
varchar2 |
||||
user_ |
varchar2 |
||||
user_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: