goal |
Gamification Goal
Catalog: Odoo
Schema: gamification
Documentation:
Goal instance for a user
An individual goal for a user on a specified time period
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 goal are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
challenge_id_label |
string |
|
☐ |
Challenge that generated the goal, assign challenge to users to generate goals with a value in this field. |
challenge_id |
string |
|
☐ |
Challenge that generated the goal, assign challenge to users to generate goals with a value in this field. |
closed |
boolean |
Closed goal |
☐ |
|
completeness |
decimal |
Completeness |
☐ |
|
computation_mode |
string |
Computation Mode |
☐ |
Define how the goals will be computed. The result of the operation will be stored in the field 'Current'. |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
current |
decimal |
Current Value |
☑ |
|
definition_condition |
string |
Definition Condition |
☐ |
A goal is considered as completed when the current value is compared to the value to reach |
definition_description |
string |
Definition Description |
☐ |
|
definition_display |
string |
Display Mode |
☐ |
|
definition_id_label |
string |
|
☐ |
|
definition_id |
string |
|
☐ |
|
definition_suffix |
string |
Suffix |
☐ |
The currency and suffix field |
display_name |
string |
Display Name |
☐ |
|
end_date |
datetime |
End Date |
☐ |
|
id |
int32 |
ID |
☐ |
|
last_update |
datetime |
Last Update |
☐ |
In case of manual goal, reminders are sent if the goal as not been updated for a while (defined in challenge). Ignored in case of non-manual goal or goal not linked to a challenge. |
line_id_label |
string |
|
☐ |
|
line_id |
string |
|
☐ |
|
remind_update_delay |
int32 |
Remind delay |
☐ |
The number of days after which the user assigned to a manual goal will be reminded. Never reminded if no value is specified. |
start_date |
datetime |
Start Date |
☐ |
|
state |
string |
State |
☑ |
|
target_goal |
decimal |
To Reach |
☑ |
|
to_update |
boolean |
To update |
☐ |
|
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