invantive documentation
Invantive Support ForumsLog In / Sign Up

challenge: Odoo itgen_odoo_challenge

read only per partition

  • Catalog: Odoo
  • Schema: gamification
  • Label: itgen_odoo_challenge

Gamification Challenge

Can only retrieve data.

Summary

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)

Table Columns

The columns of the table challenge 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
challenge_category varchar2 Appears in Define the visibility of the challenge through menus
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
description varchar2 Description
display_name varchar2 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 varchar2
last_report_date datetime Last Report Date
line_ids varchar2 List of goals that will be set
manager_id varchar2
manager_id_label varchar2
message_attachment_count int32 Attachment Count
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Number of Actions Number of messages which requires an action
message_partner_ids varchar2
name varchar2 Challenge Name
next_report_date datetime Next Report Date
period varchar2 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 varchar2 Report Frequency
report_message_group_id varchar2 Group that will receive a copy of the report in addition to the user
report_message_group_id_label varchar2 Group that will receive a copy of the report in addition to the user
report_template_id varchar2
report_template_id_label varchar2
reward_failure boolean Reward Bests if not Succeeded?
reward_first_id varchar2
reward_first_id_label varchar2
reward_id varchar2
reward_id_label varchar2
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 varchar2
reward_second_id_label varchar2
reward_third_id varchar2
reward_third_id_label varchar2
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 varchar2 State
user_count int32 # Users
user_domain varchar2 User domain
user_ids varchar2
visibility_mode varchar2 Display Mode
website_message_ids varchar2 Website communication history
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: