goal_definition: Odoo itgen_odoo_goal_definition
read only per partition
- Catalog:
Odoo - Schema:
gamification - Label: itgen_odoo_goal_definition
Gamification Goal Definition
Can only retrieve data.
Summary
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
Table Columns
The columns of the table goal_definition 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 |
|---|---|---|---|---|---|
action_ |
varchar2 |
The action that will be called to update the goal value. | |||
action_ |
varchar2 |
The action that will be called to update the goal value. | |||
batch_ |
varchar2 |
In batch mode, this indicates which field distinguishes one user from the other, e.g. user_id, partner_id... | |||
batch_ |
varchar2 |
In batch mode, this indicates which field distinguishes one user from the other, e.g. user_id, partner_id... | |||
batch_ |
boolean |
Batch Mode | Evaluate the expression in batch instead of once for each user | ||
batch_ |
varchar2 |
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_ |
varchar2 |
Computation Mode | Define how the goals will be computed. The result of the operation will be stored in the field 'Current'. | ||
compute_ |
varchar2 |
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 |
varchar2 |
Goal Performance | A goal is considered as completed when the current value is compared to the value to reach | ||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
description |
varchar2 |
Goal Description | |||
display_ |
varchar2 |
Displayed as | |||
display_ |
varchar2 |
Display Name | |||
domain |
varchar2 |
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_ |
varchar2 |
The date to use for the time period evaluated | |||
field_ |
varchar2 |
The date to use for the time period evaluated | |||
field_ |
varchar2 |
||||
field_ |
varchar2 |
||||
full_ |
varchar2 |
Full Suffix | The currency and suffix field | ||
id |
int32 |
ID | |||
model_ |
varchar2 |
||||
model_ |
varchar2 |
||||
model_ |
varchar2 |
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 |
varchar2 |
Goal Definition | |||
res_ |
varchar2 |
ID Field of user | The field name on the user profile (res.users) containing the value for res_id for action. | ||
suffix |
varchar2 |
Suffix | The unit of the target and current values | ||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: