channel |
Course
Catalog: Odoo
Schema: slide
Documentation:
A channel is a container of slides.
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 channel are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
access_token |
string |
Security Token |
☐ |
|
active |
boolean |
Active |
☐ |
|
activity_calendar_event_id_label |
string |
|
☐ |
|
activity_calendar_event_id |
string |
|
☐ |
|
activity_date_deadline |
datetime |
Next Activity Deadline |
☐ |
|
activity_exception_decoration |
string |
Activity Exception Decoration |
☐ |
Type of the exception activity on record. |
activity_exception_icon |
string |
Icon |
☐ |
Icon to indicate an exception activity. |
activity_ids |
string |
|
☐ |
|
activity_state |
string |
Activity State |
☐ |
Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities. |
activity_summary |
string |
Next Activity Summary |
☐ |
|
activity_type_icon |
string |
Activity Type Icon |
☐ |
Font awesome icon e.g. fa-tasks |
activity_type_id_label |
string |
|
☐ |
|
activity_type_id |
string |
|
☐ |
|
activity_user_id_label |
string |
|
☐ |
|
activity_user_id |
string |
|
☐ |
|
allow_comment |
boolean |
Allow rating on Course |
☐ |
Allow Attendees to like and comment your content and to submit reviews on your course. |
can_comment |
boolean |
Can Comment |
☐ |
|
can_publish |
boolean |
Can Publish |
☐ |
|
can_review |
boolean |
Can Review |
☐ |
|
can_upload |
boolean |
Can Upload |
☐ |
|
can_vote |
boolean |
Can Vote |
☐ |
|
channel_partner_ids |
string |
|
☐ |
|
channel_type |
string |
Course type |
☑ |
|
color |
int32 |
Color Index |
☐ |
Used to decorate kanban view |
completed_template_id_label |
string |
|
☐ |
Defines the email your Attendees will receive once they reach the end of your course. |
completed_template_id |
string |
|
☐ |
Defines the email your Attendees will receive once they reach the end of your course. |
completed |
boolean |
Done |
☐ |
|
completion |
int32 |
Completion |
☐ |
|
cover_properties |
string |
Cover Properties |
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
description_html |
string |
Detailed Description |
☐ |
|
description_short |
string |
Short Description |
☐ |
The description that is displayed on the course card |
description |
string |
Description |
☐ |
The description that is displayed on top of the course page, just below the title |
display_name |
string |
Display Name |
☐ |
|
enroll_group_ids |
string |
|
☐ |
Members of those groups are automatically added as members of the channel. |
enroll_msg |
string |
Enroll Message |
☐ |
Message explaining the enroll process |
enroll |
string |
Enroll Policy |
☑ |
Defines how people can enroll to your Course. |
has_message |
boolean |
Has Message |
☐ |
|
has_requested_access |
boolean |
Access Requested |
☐ |
|
id |
int32 |
ID |
☐ |
|
image_1024 |
byte[] |
Image 1024 |
☐ |
|
image_128 |
byte[] |
Image 128 |
☐ |
|
image_1920 |
byte[] |
Image |
☐ |
|
image_256 |
byte[] |
Image 256 |
☐ |
|
image_512 |
byte[] |
Image 512 |
☐ |
|
is_member |
boolean |
Is Member |
☐ |
|
is_published |
boolean |
Is Published |
☐ |
|
is_seo_optimized |
boolean |
SEO optimized |
☐ |
|
karma_gen_channel_finish |
int32 |
Course finished |
☐ |
|
karma_gen_channel_rank |
int32 |
Course ranked |
☐ |
|
karma_gen_slide_vote |
int32 |
Lesson voted |
☐ |
|
karma_review |
int32 |
Add Review |
☐ |
Karma needed to add a review on the course |
karma_slide_comment |
int32 |
Add Comment |
☐ |
Karma needed to add a comment on a slide of this course |
karma_slide_vote |
int32 |
Vote |
☐ |
Karma needed to like/dislike a slide of this course. |
members_count |
int32 |
Attendees count |
☐ |
|
members_done_count |
int32 |
Attendees Done Count |
☐ |
|
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 |
|
☐ |
|
my_activity_date_deadline |
datetime |
My Activity Deadline |
☐ |
|
name |
string |
Name |
☑ |
|
nbr_article |
int32 |
Articles |
☐ |
|
nbr_certification |
int32 |
Number of Certifications |
☐ |
|
nbr_document |
int32 |
Documents |
☐ |
|
nbr_infographic |
int32 |
Infographics |
☐ |
|
nbr_quiz |
int32 |
Number of Quizs |
☐ |
|
nbr_video |
int32 |
Videos |
☐ |
|
partner_has_new_content |
boolean |
Partner Has New Content |
☐ |
|
partner_ids |
string |
|
☐ |
All members of the channel. |
promote_strategy |
string |
Featured Content |
☐ |
Defines the content that will be promoted on the course home page |
promoted_slide_id_label |
string |
|
☐ |
|
promoted_slide_id |
string |
|
☐ |
|
publish_template_id_label |
string |
|
☐ |
Defines the email your Attendees will receive each time you upload new content. |
publish_template_id |
string |
|
☐ |
Defines the email your Attendees will receive each time you upload new content. |
rating_avg_stars |
decimal |
Rating Average (Stars) |
☐ |
|
rating_avg_text |
string |
Rating Avg Text |
☐ |
|
rating_avg |
decimal |
Average Rating |
☐ |
|
rating_count |
int32 |
Rating count |
☐ |
|
rating_ids |
string |
|
☐ |
|
rating_last_feedback |
string |
Rating Last Feedback |
☐ |
|
rating_last_image |
byte[] |
Rating Last Image |
☐ |
|
rating_last_text |
string |
Rating Text |
☐ |
|
rating_last_value |
decimal |
Rating Last Value |
☐ |
|
rating_percentage_satisfaction |
decimal |
Rating Satisfaction |
☐ |
|
seo_name |
string |
Seo name |
☐ |
|
sequence |
int32 |
Sequence |
☐ |
|
share_channel_template_id_label |
string |
|
☐ |
Email template used when sharing a channel |
share_channel_template_id |
string |
|
☐ |
Email template used when sharing a channel |
share_slide_template_id_label |
string |
|
☐ |
Email template used when sharing a slide |
share_slide_template_id |
string |
|
☐ |
Email template used when sharing a slide |
slide_category_ids |
string |
|
☐ |
|
slide_content_ids |
string |
|
☐ |
|
slide_ids |
string |
|
☐ |
|
slide_last_update |
datetime |
Last Update |
☐ |
|
slide_partner_ids |
string |
|
☐ |
|
tag_ids |
string |
|
☐ |
Used to categorize and filter displayed channels/courses |
total_slides |
int32 |
Number of Contents |
☐ |
|
total_time |
decimal |
Duration |
☐ |
|
total_views |
int32 |
Visits |
☐ |
|
total_votes |
int32 |
Votes |
☐ |
|
upload_group_ids |
string |
|
☐ |
Group of users allowed to publish contents on a documentation course. |
user_id_label |
string |
|
☐ |
|
user_id |
string |
|
☐ |
|
visibility |
string |
Visibility |
☑ |
Defines who can access your courses and their content. |
website_default_background_image_url |
string |
Background image URL |
☐ |
|
website_id_label |
string |
|
☐ |
Restrict publishing to this website. |
website_id |
string |
|
☐ |
Restrict publishing to this website. |
website_message_ids |
string |
|
☐ |
Website communication history |
website_meta_description |
string |
Website meta description |
☐ |
|
website_meta_keywords |
string |
Website meta keywords |
☐ |
|
website_meta_og_img |
string |
Website opengraph image |
☐ |
|
website_meta_title |
string |
Website meta title |
☐ |
|
website_published |
boolean |
Visible on current website |
☐ |
|
website_url |
string |
Website URL |
☐ |
The full URL to access the document through the website. |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826