Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: gamification > Tables

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

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer