task_type |
Task Stage
Catalog: Odoo
Schema: project
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 task_type are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
active |
boolean |
Active |
☐ |
|
auto_validation_kanban_state |
boolean |
Automatic Kanban Status |
☐ |
Automatically modify the kanban state when the customer replies to the feedback for this stage.* Good feedback from the customer will update the kanban state to 'ready for the new stage' (green bullet).* Neutral or bad feedback will set the kanban state to 'blocked' (red bullet). |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
description |
string |
Description |
☐ |
|
disabled_rating_warning |
string |
Disabled Rating Warning |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
fold |
boolean |
Folded in Kanban |
☐ |
If enabled, this stage will be displayed as folded in the Kanban view of your tasks. Tasks in a folded stage are considered as closed. |
id |
int32 |
ID |
☐ |
|
legend_blocked |
string |
Red Kanban Label |
☑ |
|
legend_done |
string |
Green Kanban Label |
☑ |
|
legend_normal |
string |
Grey Kanban Label |
☑ |
|
mail_template_id_label |
string |
|
☐ |
If set, an email will be automatically sent to the customer when the task reaches this stage. |
mail_template_id |
string |
|
☐ |
If set, an email will be automatically sent to the customer when the task reaches this stage. |
name |
string |
Name |
☑ |
|
project_ids |
string |
|
☐ |
Projects in which this stage is present. If you follow a similar workflow in several projects, you can share this stage among them and get consolidated information this way. |
rating_template_id_label |
string |
|
☐ |
If set, a rating request will automatically be sent by email to the customer when the task reaches this stage. Alternatively, it will be sent at a regular interval as long as the task remains in this stage, depending on the configuration of your project. To use this feature make sure that the 'Customer Ratings' option is enabled on your project. |
rating_template_id |
string |
|
☐ |
If set, a rating request will automatically be sent by email to the customer when the task reaches this stage. Alternatively, it will be sent at a regular interval as long as the task remains in this stage, depending on the configuration of your project. To use this feature make sure that the 'Customer Ratings' option is enabled on your project. |
sequence |
int32 |
Sequence |
☐ |
|
sms_template_id_label |
string |
|
☐ |
If set, an SMS Text Message will be automatically sent to the customer when the task reaches this stage. |
sms_template_id |
string |
|
☐ |
If set, an SMS Text Message will be automatically sent to the customer when the task reaches this stage. |
user_id_label |
string |
|
☐ |
|
user_id |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826