goal_definition |
Gamification Goal Definition
Catalog: Odoo
Schema: gamification
Documentation:
Goal definition
A goal definition contains the way to evaluate an objective
Each module wanting to be able to set goals to the users needs to create
a new gamification_goal_definition
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_definition are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
action_id_label |
string |
|
☐ |
The action that will be called to update the goal value. |
action_id |
string |
|
☐ |
The action that will be called to update the goal value. |
batch_distinctive_field_label |
string |
|
☐ |
In batch mode, this indicates which field distinguishes one user from the other, e.g. user_id, partner_id... |
batch_distinctive_field |
string |
|
☐ |
In batch mode, this indicates which field distinguishes one user from the other, e.g. user_id, partner_id... |
batch_mode |
boolean |
Batch Mode |
☐ |
Evaluate the expression in batch instead of once for each user |
batch_user_expression |
string |
Evaluated expression for batch mode |
☐ |
The value to compare with the distinctive field. The expression can contain reference to 'user' which is a browse record of the current user, e.g. user.id, user.partner_id.id... |
computation_mode |
string |
Computation Mode |
☑ |
Define how the goals will be computed. The result of the operation will be stored in the field 'Current'. |
compute_code |
string |
Python Code |
☐ |
Python code to be executed for each user. 'result' should contains the new current value. Evaluated user can be access through object.user_id. |
condition |
string |
Goal Performance |
☑ |
A goal is considered as completed when the current value is compared to the value to reach |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
description |
string |
Goal Description |
☐ |
|
display_mode |
string |
Displayed as |
☑ |
|
display_name |
string |
Display Name |
☐ |
|
domain |
string |
Filter Domain |
☑ |
Domain for filtering records. General rule, not user depending, e.g. [('state', '=', 'done')]. The expression can contain reference to 'user' which is a browse record of the current user if not in batch mode. |
field_date_id_label |
string |
|
☐ |
The date to use for the time period evaluated |
field_date_id |
string |
|
☐ |
The date to use for the time period evaluated |
field_id_label |
string |
|
☐ |
|
field_id |
string |
|
☐ |
|
full_suffix |
string |
Full Suffix |
☐ |
The currency and suffix field |
id |
int32 |
ID |
☐ |
|
model_id_label |
string |
|
☐ |
|
model_id |
string |
|
☐ |
|
model_inherited_ids |
string |
|
☐ |
The list of models that extends the current model. |
monetary |
boolean |
Monetary Value |
☐ |
The target and current value are defined in the company currency. |
name |
string |
Goal Definition |
☑ |
|
res_id_field |
string |
ID Field of user |
☐ |
The field name on the user profile (res.users) containing the value for res_id for action. |
suffix |
string |
Suffix |
☐ |
The unit of the target and current values |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826