invantive documentation
Forum di supporto InvantiveAccedi / Registrati

stream_post: Odoo itgen_odoo_stream_post

read only per partition

  • Catalogo: Odoo
  • Schema: social
  • Etichetta: itgen_odoo_stream_post

Social Stream Post

È possibile solo recuperare i dati.

A 'stream' post, as opposed to a regular social.post, references a post that actually exists on a social.media external database (a Facebook post, a Tweet, ...).

Stream posts are created by fetching data from the related social media third party API.
They should not be directly created/modified.

social.stream.posts are used to fill the 'Feed' view that allows users to follow the social.media activity
based on their interest (a Facebook Page, a Twitter hashtag, ...).
They are directly created by their related social.stream.

Colonne della tabella

Di seguito sono riportate le colonne della tabella stream_post. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
account_id varchar2
account_id_label varchar2
author_link varchar2 Author Link Author link to the external social.media (ex: link to the Twitter Account).
author_name varchar2 Nome dell'autore The post author name based on third party information (ex: 'John Doe').
company_id varchar2 Link an account to a company to restrict its usage or keep empty to let all companies use it.
company_id_label varchar2 Link an account to a company to restrict its usage or keep empty to let all companies use it.
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
display_name varchar2 Nome visualizzato
facebook_author_id varchar2 Facebook Author ID
facebook_comments_count int32 Comments
facebook_is_event_post boolean Is event post
facebook_likes_count int32 Likes
facebook_post_id varchar2 Facebook Post ID
facebook_reach int32 Reach
facebook_shares_count int32 Shares
facebook_user_likes boolean User Likes
formatted_published_date varchar2 Formatted Published Date
id int32 ID
instagram_comments_count int32 Instagram Comments
instagram_facebook_author_id varchar2 Instagram Facebook Author ID The Facebook ID of this Instagram post author, used to fetch the profile picture.
instagram_likes_count int32 Instagram Likes
instagram_post_id varchar2 Instagram Post ID
instagram_post_link varchar2 Instagram Post URL
link_description varchar2 Link Description
link_image_url varchar2 Link Image URL
link_title varchar2 Link Title
link_url varchar2 URL del collegamento
linkedin_author_id varchar2 LinkedIn author ID
linkedin_author_image_url varchar2 LinkedIn author image URL
linkedin_author_urn varchar2 LinkedIn author URN
linkedin_author_vanity_name varchar2 LinkedIn Vanity Name Vanity name, used to generate a link to the author
linkedin_comments_count int32 LinkedIn Comments
linkedin_likes_count int32 LinkedIn Likes
linkedin_post_urn varchar2 LinkedIn post URN
media_type varchar2 Related Social Media Used to make comparisons when we need to restrict some features to a specific media ('facebook', 'twitter', ...).
message varchar2 Message
post_link varchar2 Post Link Post link to the external social.media (ex: link to the actual Facebook Post).
published_date datetime Published date The post published date based on third party information.
stream_id varchar2
stream_id_label varchar2
stream_post_image_ids varchar2 Images that were shared with this post.
stream_post_image_urls varchar2 Stream Post Images URLs
twitter_author_id varchar2 Twitter Author ID
twitter_can_retweet boolean Twitter Can Retweet
twitter_comments_count int32 Twitter Comments
twitter_likes_count int32 Twitter Likes
twitter_profile_image_url varchar2 Twitter Profile Image URL
twitter_quoted_tweet_author_link varchar2 Quoted tweet author Link
twitter_quoted_tweet_author_name varchar2 Quoted tweet author Name
twitter_quoted_tweet_id_str varchar2 Twitter Quoted Tweet ID
twitter_quoted_tweet_message varchar2 Quoted tweet message
twitter_quoted_tweet_profile_image_url varchar2 Quoted tweet profile image URL
twitter_retweet_count int32 Re-tweets
twitter_retweeted_tweet_id_str varchar2 Twitter Retweet ID
twitter_screen_name varchar2 Twitter Screen Name
twitter_tweet_id varchar2 Twitter Tweet ID
twitter_user_likes boolean Twitter User Likes
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2
youtube_comments_count int32 YouTube Comments Count
youtube_dislikes_count int32 YouTube Dislikes
youtube_likes_count int32 YouTube Likes
youtube_likes_ratio int32 YouTube Likes Ratio
youtube_thumbnail_url varchar2 YouTube Thumbnail Url
youtube_video_id varchar2 YouTube Video ID
youtube_views_count int32 YouTube Views

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: