invantive documentation
Invantive Support ForumsLog In / Sign Up

team: Odoo itgen_odoo_team

read only per partition

  • Catalog: Odoo
  • Schema: helpdesk
  • Label: itgen_odoo_team

Helpdesk Team

Can only retrieve data.

Table Columns

The columns of the table team 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
access_instruction_message varchar2 Access Instruction Message
active boolean Active
alias_bounced_content varchar2 Custom Bounced Message If set, this content will automatically be sent out to unauthorized users instead of the default message.
alias_contact varchar2 Alias Contact Security Policy to post a message on the document using the mailgateway. - everyone: everyone can post - partners: only authenticated partners - followers: only followers of the related document or members of following channels
alias_defaults varchar2 Default Values A Python dictionary that will be evaluated to provide default values when creating new records for this alias.
alias_domain varchar2 Alias domain
alias_email_from varchar2 Alias Email From
alias_force_thread_id int32 Record Thread ID Optional ID of a thread (record) to which all incoming messages will be attached, even if they did not reply to it. If set, this will disable the creation of new records completely.
alias_id varchar2
alias_id_label varchar2
alias_model_id varchar2 The model (Odoo Document Kind) to which this alias corresponds. Any incoming email that does not reply to an existing record will cause the creation of a new record of this model (e.g. a Project Task)
alias_model_id_label varchar2 The model (Odoo Document Kind) to which this alias corresponds. Any incoming email that does not reply to an existing record will cause the creation of a new record of this model (e.g. a Project Task)
alias_name varchar2 Alias Name The name of the email alias, e.g. 'jobs' if you want to catch emails for jobs@example.odoo.com
alias_parent_model_id varchar2 Parent model holding the alias. The model holding the alias reference is not necessarily the model given by alias_model_id (example: project (parent_model) and task (model))
alias_parent_model_id_label varchar2 Parent model holding the alias. The model holding the alias reference is not necessarily the model given by alias_model_id (example: project (parent_model) and task (model))
alias_parent_thread_id int32 Parent Record Thread ID ID of the parent record holding the alias (example: project holding the task creation alias)
alias_status varchar2 Alias Status Alias status assessed on the last message received.
alias_user_id varchar2 The owner of records created upon receiving emails on this alias. If this field is not set the system will attempt to find the right owner based on the sender (From) address, or will use the Administrator account if no system user is found for that address.
alias_user_id_label varchar2 The owner of records created upon receiving emails on this alias. If this field is not set the system will attempt to find the right owner based on the sender (From) address, or will use the Administrator account if no system user is found for that address.
allow_portal_ticket_closing boolean Closure by Customers
assign_method varchar2 Assignment Method New tickets will automatically be assigned to the team members that are available, according to their working hours and their time off.
auto_assignment boolean Automatic Assignment
auto_close_day int32 Inactive Period(days) Period of inactivity after which tickets will be automatically closed.
auto_close_ticket boolean Automatic Closing
color int32 Color Index
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
description varchar2 About Team
display_alias_name varchar2 Alias email
display_name varchar2 Display Name
from_stage_ids varchar2
fsm_project_id varchar2
fsm_project_id_label varchar2
has_external_mail_server boolean Has External Mail Server
has_message boolean Has Message
id int32 ID
member_ids varchar2
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
name varchar2 Helpdesk Team
open_ticket_count int32 # Open Tickets
portal_show_rating boolean Ratings on Website If enabled, portal users will have access to your customer satisfaction statistics from the last 30 days in their portal. They will only have access to the ratings themselves, and not to the written feedback if any was left. You can also manually hide ratings of your choosing.
privacy_visibility varchar2 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.
privacy_visibility_warning varchar2 Privacy Visibility Warning
rating_avg numeric Average Rating
rating_avg_percentage numeric Average Rating (%)
rating_count int32 # Ratings
rating_ids varchar2
rating_percentage_satisfaction int32 Rating Satisfaction Percentage of happy ratings
resource_calendar_id varchar2 Working hours used to determine the deadline of SLA Policies.
resource_calendar_id_label varchar2 Working hours used to determine the deadline of SLA Policies.
sequence int32 Sequence
show_knowledge_base boolean Show Knowledge Base
sla_failed int32 Failed SLA Ticket
sla_policy_count int32 # SLA Policy
stage_ids varchar2 Stages the team will use. This team's tickets will only be able to be in these stages.
success_rate numeric Success Rate
ticket_closed int32 Ticket Closed
ticket_ids varchar2
ticket_properties varchar2 Ticket Properties
to_stage_id varchar2
to_stage_id_label varchar2
unassigned_tickets int32 Unassigned Tickets
urgent_ticket int32 # Urgent Ticket
use_alias boolean Email Alias
use_coupons boolean Coupons
use_credit_notes boolean Refunds
use_fsm boolean Field Service
use_helpdesk_sale_timesheet boolean Time Billing
use_helpdesk_timesheet boolean Timesheets
use_product_repairs boolean Repairs
use_product_returns boolean Returns
use_rating boolean Customer Ratings
use_sla boolean SLA Policies
use_twitter boolean Twitter
use_website_helpdesk_form boolean Website Form
use_website_helpdesk_forum boolean Community Forum
use_website_helpdesk_knowledge boolean Knowledge
use_website_helpdesk_livechat boolean Live Chat
use_website_helpdesk_slides boolean Enable eLearning
website_message_ids varchar2 Website communication history
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: