Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: helpdesk > Tables

ticket

Helpdesk Ticket

Catalog: Odoo

Schema: helpdesk

The data in this table is partitioned per value of the column.

This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.

Table Columns

The columns of the table ticket are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

access_token

string

Security Token

 

access_url

string

Portal Access URL

Customer Portal URL

access_warning

string

Access warning

 

active

boolean

Active

 

activity_calendar_event_id_label

string

 

 

activity_calendar_event_id

string

 

 

activity_date_deadline

datetime

Next Activity Deadline

 

activity_exception_decoration

string

Activity Exception Decoration

Type of the exception activity on record.

activity_exception_icon

string

Icon

Icon to indicate an exception activity.

activity_ids

string

 

 

activity_state

string

Activity State

Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities.

activity_summary

string

Next Activity Summary

 

activity_type_icon

string

Activity Type Icon

Font awesome icon e.g. fa-tasks

activity_type_id_label

string

 

 

activity_type_id

string

 

 

activity_user_id_label

string

 

 

activity_user_id

string

 

 

answered_customer_message_count

int32

# Exchanges

 

assign_date

datetime

First assignment date

 

assign_hours

int32

Time to first assignment (hours)

 

avg_response_hours

decimal

Average Hours to Respond

 

campaign_id_label

string

 

This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special

campaign_id

string

 

This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special

close_date

datetime

Close date

 

close_hours

int32

Time to close (hours)

 

closed_by_partner

boolean

Closed by Partner

 

color

int32

Color Index

 

commercial_partner_id_label

string

 

 

commercial_partner_id

string

 

 

company_id_label

string

 

 

company_id

string

 

 

create_date

datetime

Created on

 

create_uid_label

string

 

 

create_uid

string

 

 

date_last_stage_update

datetime

Last Stage Update

 

description

string

Description

 

display_name

string

Display Name

 

domain_user_ids

string

 

 

email_cc

string

Email cc

 

first_response_hours

decimal

Hours to First Response

 

fold

boolean

Folded in Kanban

Tickets in a folded stage are considered as closed.

fsm_task_count

int32

Fsm Task Count

 

fsm_task_ids

string

 

Tasks generated from this ticket

has_message

boolean

Has Message

 

id

int32

ID

 

is_partner_email_update

boolean

Partner Email will Update

 

is_partner_phone_update

boolean

Partner Phone will Update

 

kanban_state_label

string

Kanban State Label

 

kanban_state

string

Kanban State

 

legend_blocked

string

Kanban Blocked Explanation

 

legend_done

string

Kanban Valid Explanation

 

legend_normal

string

Kanban Ongoing Explanation

 

medium_id_label

string

 

This is the method of delivery, e.g. Postcard, Email, or Banner Ad

medium_id

string

 

This is the method of delivery, e.g. Postcard, Email, or Banner Ad

message_attachment_count

int32

Attachment Count

 

message_follower_ids

string

 

 

message_has_error_counter

int32

Number of errors

Number of messages with delivery error

message_has_error

boolean

Message Delivery error

If checked, some messages have a delivery error.

message_has_sms_error

boolean

SMS Delivery error

If checked, some messages have a delivery error.

message_ids

string

 

 

message_is_follower

boolean

Is Follower

 

message_main_attachment_id_label

string

 

 

message_main_attachment_id

string

 

 

message_needaction_counter

int32

Number of Actions

Number of messages which requires an action

message_needaction

boolean

Action Needed

If checked, new messages require your attention.

message_partner_ids

string

 

 

my_activity_date_deadline

datetime

My Activity Deadline

 

name

string

Subject

 

oldest_unanswered_customer_message_date

datetime

Oldest Unanswered Customer Message Date

 

open_hours

int32

Open Time (hours)

 

partner_email

string

Customer Email

 

partner_id_label

string

 

 

partner_id

string

 

 

partner_name

string

Customer Name

 

partner_open_ticket_count

int32

Number of other open tickets from the same partner

 

partner_phone

string

Customer Phone

 

partner_ticket_count

int32

Number of other tickets from the same partner

 

partner_ticket_ids

string

 

 

priority

string

Priority

 

properties

string

Properties

 

rating_avg_text

string

Rating Avg Text

 

rating_avg

decimal

Average Rating

 

rating_count

int32

Rating count

 

rating_ids

string

 

 

rating_last_feedback

string

Rating Last Feedback

 

rating_last_image

byte[]

Rating Last Image

 

rating_last_text

string

Rating Text

 

rating_last_value

decimal

Rating Last Value

 

rating_percentage_satisfaction

decimal

Rating Satisfaction

 

sale_order_id_label

string

 

 

sale_order_id

string

 

 

sla_deadline_hours

decimal

Hours to SLA Deadline

 

sla_deadline

datetime

SLA Deadline

 

sla_fail

boolean

Failed SLA Policy

 

sla_ids

string

 

 

sla_reached_late

boolean

Has SLA reached late

 

sla_reached

boolean

Has SLA reached

 

sla_status_ids

string

 

 

sla_success

boolean

Success SLA Policy

 

source_id_label

string

 

This is the source of the link, e.g. Search Engine, another domain, or name of email list

source_id

string

 

This is the source of the link, e.g. Search Engine, another domain, or name of email list

stage_id_label

string

 

 

stage_id

string

 

 

tag_ids

string

 

 

team_id_label

string

 

 

team_id

string

 

 

team_privacy_visibility

string

Team Visibility

People to whom this helpdesk team and its tickets will be visible.- Invited internal users: internal users can access the team and the tickets they are following. This access can be modified on each ticket individually by adding or removing the user as follower.A user with the helpdesk > administrator access right level can still access this team and its tickets, even if they are not explicitely part of the followers.- All internal users: all internal users can access the team and all of its tickets without distinction.- Invited portal users and all internal users: all internal users can access the team and all of its tickets without distinction.Portal users can only access the tickets they are following. This access can be modified on each ticket individually by adding or removing the portal user as follower.

ticket_ref

string

Ticket IDs Sequence

 

ticket_type_id_label

string

 

 

ticket_type_id

string

 

 

total_response_hours

decimal

Total Exchange Time in Hours

 

use_coupons

boolean

Use Coupons

 

use_credit_notes

boolean

Use Credit Notes

 

use_fsm

boolean

Field Service

 

use_product_repairs

boolean

Use Repairs

 

use_product_returns

boolean

Use Returns

 

use_rating

boolean

Use Customer Ratings

 

use_sla

boolean

SLA Policies

 

user_id_label

string

 

 

user_id

string

 

 

website_message_ids

string

 

Website communication history

write_date

datetime

Last Updated on

 

write_uid_label

string

 

 

write_uid

string

 

 

 

01-03-2023 15:29 Version 22.1.135-BETA+3826

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer