invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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_id varchar2 Challenge that generated the goal, assign challenge to users to generate goals with a value in this field.
challenge_id_label 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_mode varchar2 Computation Mode Define how the goals will be computed.The result of the operation will be stored in the field 'Current'.
create_date datetime Creado en
create_uid varchar2
create_uid_label varchar2
current numeric Valor Actual
definition_condition varchar2 Definition Condition A goal is considered as completed when the current value is compared to the value to reach
definition_description varchar2 Definition Description
definition_display varchar2 Display Mode
definition_id varchar2
definition_id_label varchar2
definition_suffix varchar2 Suffix The currency and suffix field
display_name varchar2 Nombre para mostrar
end_date datetime Fecha Final
id int32 ID
last_update 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_id varchar2
line_id_label varchar2
remind_update_delay 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_date datetime Fecha Inicial
state varchar2 State
target_goal numeric To Reach
to_update boolean To update
user_id varchar2
user_id_label varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: