challenge_line |
Gamification generic goal for challenge
Catalog: Odoo
Schema: gamification
Documentation:
Gamification challenge line
Predefined goal for 'gamification_challenge'
These are generic list of goals with only the target goal defined
Should only be created for the gamification.challenge object
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 challenge_line are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
challenge_id_label |
string |
|
☐ |
|
challenge_id |
string |
|
☐ |
|
condition |
string |
Condition |
☐ |
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 |
|
☐ |
|
definition_full_suffix |
string |
Suffix |
☐ |
The currency and suffix field |
definition_id_label |
string |
|
☐ |
|
definition_id |
string |
|
☐ |
|
definition_monetary |
boolean |
Monetary |
☐ |
The target and current value are defined in the company currency. |
definition_suffix |
string |
Unit |
☐ |
The unit of the target and current values |
display_name |
string |
Display Name |
☐ |
|
id |
int32 |
ID |
☐ |
|
name |
string |
Name |
☐ |
|
sequence |
int32 |
Sequence |
☐ |
|
target_goal |
decimal |
Target Value to Reach |
☑ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826