invantive documentation
Invantive Support ForumsLog In / Sign Up

sla_report_analysis: Odoo itgen_odoo_sla_report_analysis

read only per partition

  • Catalog: Odoo
  • Schema: helpdesk
  • Label: itgen_odoo_sla_report_analysis

SLA Status Analysis

Can only retrieve data.

Table Columns

The columns of the table sla_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
close_date datetime Close date
company_id varchar2
company_id_label varchar2
create_date datetime Ticket Create Date
display_name varchar2 Display Name
failed_sla_rate numeric % of Failed SLA
id int32 ID
ongoing_sla_rate numeric % of SLA In Progress
partner_id varchar2
partner_id_label varchar2
priority varchar2 Minimum Priority
sale_order_id varchar2
sale_order_id_label varchar2
sla_deadline datetime SLA Deadline
sla_exceeded_hours int32 Working Hours to Reach SLA Day to reach the stage of the SLA, without taking the working calendar into account
sla_id varchar2
sla_id_label varchar2
sla_reached_datetime datetime SLA Reached Date
sla_stage_id varchar2
sla_stage_id_label varchar2
sla_status varchar2 Status
sla_status_fail boolean SLA Status Failed
sla_status_failed int32 Number of SLA Failed
sla_status_ongoing int32 Number SLA In Progress
sla_status_successful int32 Number of SLA Successful
successful_sla_rate numeric % of Successful SLA
team_id varchar2
team_id_label varchar2
ticket_assignation_hours int32 Working Hours to Assign
ticket_close_hours int32 Working Hours to Close
ticket_closed boolean Ticket Closed
ticket_deadline datetime Ticket Deadline
ticket_id varchar2
ticket_id_label varchar2
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: