invantive documentation
Invantive Support ForumsLog In / Sign Up

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_date datetime First assignment date
avg_response_hours numeric Average Hours to Respond
close_date datetime Close date
company_id varchar2
company_id_label varchar2
create_date datetime Created On
display_name varchar2 Display Name
first_response_hours numeric Hours to First Response
id int32 ID
kanban_state varchar2 Kanban State
partner_id varchar2
partner_id_label varchar2
priority varchar2 Minimum Priority
rating_last_value numeric Rating (/5)
sale_order_id varchar2
sale_order_id_label varchar2
sla_fail boolean Failed SLA Policy
team_id varchar2
team_id_label varchar2
ticket_assignation_hours numeric Hours to Assign
ticket_close_hours numeric Hours to Close
ticket_deadline datetime Ticket Deadline
ticket_deadline_hours numeric Hours to SLA Deadline
ticket_id varchar2
ticket_id_label varchar2
ticket_open_hours numeric Hours Open
ticket_stage_id varchar2
ticket_stage_id_label varchar2
ticket_type_id varchar2
ticket_type_id_label varchar2
user_id varchar2
user_id_label varchar2

Release Notes

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