goal: Odoo itgen_odoo_goal
read only per partition
- Catálogo:
Odoo - Esquema:
gamification - Etiqueta: itgen_odoo_goal
Gamification Goal
Solo puede recuperar datos.
Resumen
Goal instance for a user
An individual goal for a user on a specified time period
Columnas de la Tabla
A continuación se muestran las columnas de la tabla goal. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
challenge_ |
varchar2 |
Challenge that generated the goal, assign challenge to users to generate goals with a value in this field. | |||
challenge_ |
varchar2 |
Challenge that generated the goal, assign challenge to users to generate goals with a value in this field. | |||
closed |
boolean |
Closed goal | |||
completeness |
numeric |
Completeness | |||
computation_ |
varchar2 |
Computation Mode | Define how the goals will be computed.The result of the operation will be stored in the field 'Current'. | ||
create_ |
datetime |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
current |
numeric |
Valor Actual | |||
definition_ |
varchar2 |
Definition Condition | A goal is considered as completed when the current value is compared to the value to reach | ||
definition_ |
varchar2 |
Definition Description | |||
definition_ |
varchar2 |
Display Mode | |||
definition_ |
varchar2 |
||||
definition_ |
varchar2 |
||||
definition_ |
varchar2 |
Suffix | The currency and suffix field | ||
display_ |
varchar2 |
Nombre para mostrar | |||
end_ |
datetime |
Fecha Final | |||
id |
int32 |
ID | |||
last_ |
datetime |
Última actualización | In case of manual goal, reminders are sent if the goal as not been updated for a while (defined in challenge).Ignored in case of non-manual goal or goal not linked to a challenge. | ||
line_ |
varchar2 |
||||
line_ |
varchar2 |
||||
remind_ |
int32 |
Remind delay | The number of days after which the user assigned to a manual goal will be reminded.Never reminded if no value is specified. | ||
start_ |
datetime |
Fecha Inicial | |||
state |
varchar2 |
State | |||
target_ |
numeric |
To Reach | |||
to_ |
boolean |
To update | |||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: