challenge |
Gamification Challenge
Catalog: Odoo
Schema: gamification
Documentation:
Gamification challenge
Set of predifined objectives assigned to people with rules for recurrence and
rewards
If 'user_ids' is defined and 'period' is different than 'one', the set will
be assigned to the users for each period (eg: every 1st of each month if
'monthly' is selected)
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 are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
challenge_category |
string |
Appears in |
☑ |
Define the visibility of the challenge through menus |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
description |
string |
Description |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
end_date |
datetime |
End Date |
☐ |
The day a new challenge will be automatically closed. If no periodicity is set, will use this date as the goal end date. |
has_message |
boolean |
Has Message |
☐ |
|
id |
int32 |
ID |
☐ |
|
invited_user_ids |
string |
|
☐ |
|
last_report_date |
datetime |
Last Report Date |
☐ |
|
line_ids |
string |
|
☐ |
List of goals that will be set |
manager_id_label |
string |
|
☐ |
|
manager_id |
string |
|
☐ |
|
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
name |
string |
Challenge Name |
☑ |
|
next_report_date |
datetime |
Next Report Date |
☐ |
|
period |
string |
Periodicity |
☑ |
Period of automatic goal assignment. If none is selected, should be launched manually. |
remind_update_delay |
int32 |
Non-updated manual goals will be reminded after |
☐ |
Never reminded if no value or zero is specified. |
report_message_frequency |
string |
Report Frequency |
☑ |
|
report_message_group_id_label |
string |
|
☐ |
Group that will receive a copy of the report in addition to the user |
report_message_group_id |
string |
|
☐ |
Group that will receive a copy of the report in addition to the user |
report_template_id_label |
string |
|
☐ |
|
report_template_id |
string |
|
☐ |
|
reward_failure |
boolean |
Reward Bests if not Succeeded? |
☐ |
|
reward_first_id_label |
string |
|
☐ |
|
reward_first_id |
string |
|
☐ |
|
reward_id_label |
string |
|
☐ |
|
reward_id |
string |
|
☐ |
|
reward_realtime |
boolean |
Reward as soon as every goal is reached |
☐ |
With this option enabled, a user can receive a badge only once. The top 3 badges are still rewarded only at the end of the challenge. |
reward_second_id_label |
string |
|
☐ |
|
reward_second_id |
string |
|
☐ |
|
reward_third_id_label |
string |
|
☐ |
|
reward_third_id |
string |
|
☐ |
|
start_date |
datetime |
Start Date |
☐ |
The day a new challenge will be automatically started. If no periodicity is set, will use this date as the goal start date. |
state |
string |
State |
☑ |
|
user_count |
int32 |
# Users |
☐ |
|
user_domain |
string |
User domain |
☐ |
|
user_ids |
string |
|
☐ |
|
visibility_mode |
string |
Display Mode |
☑ |
|
website_message_ids |
string |
|
☐ |
Website communication history |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826