invantive documentation
Invantive Support ForumsLog In / Sign Up

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_id varchar2 The action that will be called to update the goal value.
action_id_label varchar2 The action that will be called to update the goal value.
batch_distinctive_field varchar2 In batch mode, this indicates which field distinguishes one user from the other, e.g. user_id, partner_id...
batch_distinctive_field_label varchar2 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 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_mode varchar2 Computation Mode Define how the goals will be computed. The result of the operation will be stored in the field 'Current'.
compute_code 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_date datetime Created on
create_uid varchar2
create_uid_label varchar2
description varchar2 Goal Description
display_mode varchar2 Displayed as
display_name 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_date_id varchar2 The date to use for the time period evaluated
field_date_id_label varchar2 The date to use for the time period evaluated
field_id varchar2
field_id_label varchar2
full_suffix varchar2 Full Suffix The currency and suffix field
id int32 ID
model_id varchar2
model_id_label varchar2
model_inherited_ids 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_id_field 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_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: