invantive documentation
Invantive Support ForumsLog In / Sign Up

channel: Odoo itgen_odoo_channel

read only per partition

  • Catalog: Odoo
  • Schema: slide
  • Label: itgen_odoo_channel

Course

Can only retrieve data.

Summary

A channel is a container of slides.

Table Columns

The columns of the table channel 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
access_token varchar2 Security Token
active boolean Active
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
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 varchar2
channel_type varchar2 Course type
color int32 Color Index Used to decorate kanban view
completed boolean Done
completed_template_id varchar2 Defines the email your Attendees will receive once they reach the end of your course.
completed_template_id_label varchar2 Defines the email your Attendees will receive once they reach the end of your course.
completion int32 Completion
cover_properties varchar2 Cover Properties
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
description varchar2 Description The description that is displayed on top of the course page, just below the title
description_html varchar2 Detailed Description
description_short varchar2 Short Description The description that is displayed on the course card
display_name varchar2 Display Name
enroll varchar2 Enroll Policy Defines how people can enroll to your Course.
enroll_group_ids varchar2 Members of those groups are automatically added as members of the channel.
enroll_msg varchar2 Enroll Message Message explaining the enroll process
has_message boolean Has Message
has_requested_access boolean Access Requested
id int32 ID
image_1024 varbinary Image 1024
image_128 varbinary Image 128
image_1920 varbinary Image
image_256 varbinary Image 256
image_512 varbinary 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 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
my_activity_date_deadline datetime My Activity Deadline
name varchar2 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 varchar2 All members of the channel.
promote_strategy varchar2 Featured Content Defines the content that will be promoted on the course home page
promoted_slide_id varchar2
promoted_slide_id_label varchar2
publish_template_id varchar2 Defines the email your Attendees will receive each time you upload new content.
publish_template_id_label varchar2 Defines the email your Attendees will receive each time you upload new content.
rating_avg numeric Average Rating
rating_avg_stars numeric Rating Average (Stars)
rating_avg_text varchar2 Rating Avg Text
rating_count int32 Rating count
rating_ids varchar2
rating_last_feedback varchar2 Rating Last Feedback
rating_last_image varbinary Rating Last Image
rating_last_text varchar2 Rating Text
rating_last_value numeric Rating Last Value
rating_percentage_satisfaction numeric Rating Satisfaction
seo_name varchar2 Seo name
sequence int32 Sequence
share_channel_template_id varchar2 Email template used when sharing a channel
share_channel_template_id_label varchar2 Email template used when sharing a channel
share_slide_template_id varchar2 Email template used when sharing a slide
share_slide_template_id_label varchar2 Email template used when sharing a slide
slide_category_ids varchar2
slide_content_ids varchar2
slide_ids varchar2
slide_last_update datetime Last Update
slide_partner_ids varchar2
tag_ids varchar2 Used to categorize and filter displayed channels/courses
total_slides int32 Number of Contents
total_time numeric Duration
total_views int32 Visits
total_votes int32 Votes
upload_group_ids varchar2 Group of users allowed to publish contents on a documentation course.
user_id varchar2
user_id_label varchar2
visibility varchar2 Visibility Defines who can access your courses and their content.
website_default_background_image_url varchar2 Background image URL
website_id varchar2 Restrict publishing to this website.
website_id_label varchar2 Restrict publishing to this website.
website_message_ids varchar2 Website communication history
website_meta_description varchar2 Website meta description
website_meta_keywords varchar2 Website meta keywords
website_meta_og_img varchar2 Website opengraph image
website_meta_title varchar2 Website meta title
website_published boolean Visible on current website
website_url varchar2 Website URL The full URL to access the document through the website.
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: