---
title: "goal_definition (Odoo)"
description: "itgen_odoo_goal_definition"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.gamification.goal_definition
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.gamification.goal_definition
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# 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 | [x] |  | 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 | [x] |  | 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 | [x] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `domain` | `varchar2` | Filter Domain | [x] |  | 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 | [x] |  |  |
| `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:

- [Odoo](/en/release-notes/drivers?driver=odoo)

