invantive documentation
Invantive Support ForumsLog In / Sign Up

sla_status: Odoo itgen_odoo_sla_status

read only per partition

  • Catalog: Odoo
  • Schema: helpdesk
  • Label: itgen_odoo_sla_status

Ticket SLA Status

Can only retrieve data.

Table Columns

The columns of the table sla_status 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
color int32 Color Index
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
deadline datetime Deadline
display_name varchar2 Display Name
exceeded_hours numeric Exceeded Working Hours Working hours exceeded for reached SLAs compared with deadline. Positive number means the SLA was reached after the deadline.
id int32 ID
reached_datetime datetime Reached Date Datetime at which the SLA stage was reached for the first time
sla_id varchar2
sla_id_label varchar2
sla_stage_id varchar2 Minimum stage a ticket needs to reach in order to satisfy this SLA.
sla_stage_id_label varchar2 Minimum stage a ticket needs to reach in order to satisfy this SLA.
status varchar2 Status
ticket_id varchar2
ticket_id_label varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Release Notes

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