invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

t_Post_streamPostsActions_summaryById: Discourse Topic Post Stream Posts Actions Summary by ID

read only REST

  • Catalogue : Discourse
  • Schéma : Topics
  • Label: Topic Post Stream Posts Actions Summary by ID

Get a single topic

Permet uniquement de récupérer des données.

Résumé

Get a single topic

Source de l'API

  • Point de terminaison : /t/{id}.json
  • Opération : get /t/{id}.json

Caractéristiques de performance

Characteristic Value
Latence moyenne d'accès (ms) 243
Nombre d'enregistrements écrits par minute 219

Le résultat peut être mis en cache côté client.

Paramètres

Name Type de données Required Default Documentation
id ``
print `` Will return up to 1000 posts in a topic

Colonnes de table

Les colonnes de la table t_Post_streamPostsActions_summaryById sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
admin char Administrator writable, ::ancestor.admin
archetype varchar2 Archetype filters on the platform, writable, ::ancestor.::ancestor.::ancestor.archetype
archived char Archived filters on the platform, writable, ::ancestor.::ancestor.::ancestor.archived
avatar_template varchar2 Modèle d'avatar writable, ::ancestor.avatar_template
avg_time varchar2 itgen_dce_avg_time writable The JSON text of the nested object.
bookmarked varchar2 Bookmarked writable The JSON text of the nested object.
can_delete char Peut être supprimé writable, ::ancestor.can_delete
can_edit char peut modifier writable, ::ancestor.can_edit
can_recover char Peut récupérer writable, ::ancestor.can_recover
can_view_edit_history char View l'historique des modifications writable, ::ancestor.can_view_edit_history
can_wiki char Peut-on « wikifier » ? writable, ::ancestor.can_wiki
category_id decimal ID de catégorie filters on the platform, writable, ::ancestor.::ancestor.::ancestor.category_id
chunk_size decimal Taille des blocs filters on the platform, writable, ::ancestor.::ancestor.::ancestor.chunk_size
closed char Closed filters on the platform, writable, ::ancestor.::ancestor.::ancestor.closed
cooked varchar2 Cooked writable, ::ancestor.cooked
created_at varchar2 Créé le writable, ::ancestor.created_at
created_at_2 varchar2 Créé à 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.created_at
deleted_at varchar2 Supprimé le writable The JSON text of the nested object.
deleted_at_2 varchar2 Supprimé à 2 h writable The JSON text of the nested object.
deleted_by varchar2 Supprimé par writable The JSON text of the nested object.
details_auto_close_at varchar2 itgen_dce_details_auto_close_at writable The JSON text of the nested object.
details_auto_close_based_on_last_post char Fermeture automatique des détails en fonction du dernier message filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.auto_close_based_on_last_post
details_auto_close_hours varchar2 itgen_dce_details_auto_close_hours writable The JSON text of the nested object.
details_can_flag_topic char Détails - Possibilité de signaler un sujet filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.can_flag_topic
details_created_by_avatar_template varchar2 Détail créé à partir d'un modèle d'avatar filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.created_by.avatar_template
details_created_by_id decimal Détails Créé par ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.created_by.id
details_created_by_username varchar2 Détails créés par [Nom d'utilisateur] filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.created_by.username
details_last_poster_avatar_template varchar2 Détails du dernier avatar d'un utilisateur - Modèle filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.last_poster.avatar_template
details_last_poster_id decimal Détails : ID du dernier contributeur filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.last_poster.id
details_last_poster_username varchar2 Détails Dernier message Nom d'utilisateur filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.last_poster.username
details_notification_level decimal Niveau de notification détaillé filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.notification_level
display_username varchar2 Afficher le nom d'utilisateur writable, ::ancestor.display_username
draft varchar2 Draft writable The JSON text of the nested object.
draft_key varchar2 Clavette d'attelage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.draft_key
draft_sequence varchar2 Séquence de brouillon writable The JSON text of the nested object.
edit_reason varchar2 Motif de la modification writable The JSON text of the nested object.
fancy_title varchar2 Titre fantaisiste filters on the platform, writable, ::ancestor.::ancestor.::ancestor.fancy_title
has_summary char Résumé filters on the platform, writable, ::ancestor.::ancestor.::ancestor.has_summary
hidden char Hidden writable, ::ancestor.hidden
hidden_reason_id varchar2 itgen_dce_hidden_reason_id writable The JSON text of the nested object.
highest_post_number decimal Nombre maximal de messages filters on the platform, writable, ::ancestor.::ancestor.::ancestor.highest_post_number
id decimal ID writable, ::ancestor.id
id_2 decimal ID 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.id
incoming_link_count decimal #Liens entrants writable, ::ancestor.incoming_link_count
last_posted_at varchar2 Dernière mise à jour le writable The JSON text of the nested object.
like_count decimal #Likes filters on the platform, writable, ::ancestor.::ancestor.::ancestor.like_count
moderator char Moderator writable, ::ancestor.moderator
name varchar2 Name writable, ::ancestor.name
participant_count decimal Nombre de participants filters on the platform, writable, ::ancestor.::ancestor.::ancestor.participant_count
pinned char Pinned filters on the platform, writable, ::ancestor.::ancestor.::ancestor.pinned
pinned_at varchar2 Épinglé à filters on the platform, writable, ::ancestor.::ancestor.::ancestor.pinned_at
pinned_globally char Épinglé au niveau mondial filters on the platform, writable, ::ancestor.::ancestor.::ancestor.pinned_globally
pinned_until varchar2 Épinglé jusqu'au writable The JSON text of the nested object.
polls_poll_name varchar2 Nom du sondage writable, ::ancestor.polls.poll.name
polls_poll_status varchar2 État du sondage writable, ::ancestor.polls.poll.status
polls_poll_type varchar2 Type de sondage writable, ::ancestor.polls.poll.type
polls_poll_voters int64 Électeurs participant au sondage writable, ::ancestor.polls.poll.voters
post_number decimal Numéro de message writable, ::ancestor.post_number
post_type decimal Type de poste writable, ::ancestor.post_type
posts_count decimal #Posts filters on the platform, writable, ::ancestor.::ancestor.::ancestor.posts_count
primary_group_flair_bg_color varchar2 itgen_dce_primary_group_flair_bg_color writable The JSON text of the nested object.
primary_group_flair_color varchar2 itgen_dce_primary_group_flair_color writable The JSON text of the nested object.
primary_group_flair_url varchar2 itgen_dce_primary_group_flair_url writable The JSON text of the nested object.
primary_group_name varchar2 Nom du groupe principal writable The JSON text of the nested object.
quote_count decimal #Quotes writable, ::ancestor.quote_count
read char Read writable, ::ancestor.read
reads decimal #Reads writable, ::ancestor.reads
reply_count decimal #Replies writable, ::ancestor.reply_count
reply_count_2 decimal Nombre de réponses : 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.reply_count
reply_to_post_number varchar2 Répondre au message n° writable The JSON text of the nested object.
score decimal Score writable, ::ancestor.score
slug varchar2 Slug filters on the platform, writable, ::ancestor.::ancestor.::ancestor.slug
staff char Staff writable, ::ancestor.staff
title varchar2 Title filters on the platform, writable, ::ancestor.::ancestor.::ancestor.title
topic_id decimal Identifiant du sujet writable, ::ancestor.topic_id
topic_slug varchar2 Slug du sujet writable, ::ancestor.topic_slug
trust_level decimal Niveau de confiance writable, ::ancestor.trust_level
unpinned varchar2 Unpinned writable The JSON text of the nested object.
updated_at varchar2 Mise à jour à writable, ::ancestor.updated_at
user_deleted char Utilisateur supprimé writable, ::ancestor.user_deleted
user_id decimal ID utilisateur writable, ::ancestor.user_id
user_id_2 decimal Identifiant utilisateur 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.user_id
user_title varchar2 Titre de l'utilisateur writable The JSON text of the nested object.
username varchar2 Nom d'Utilisateur writable, ::ancestor.username
version decimal Version writable, ::ancestor.version
views decimal Views filters on the platform, writable, ::ancestor.::ancestor.::ancestor.views
visible char Visible filters on the platform, writable, ::ancestor.::ancestor.::ancestor.visible
wiki char Wiki writable, ::ancestor.wiki
word_count varchar2 Compter le nombre de mots writable The JSON text of the nested object.
yours char Yours writable, ::ancestor.yours

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

Modifications apportées à cette table, 26.0 à 27.0

  • - avg_time
  • ~ bookmarked (database_data_type: varchar2 → char)
  • ~ bookmarked (dotnet_data_type: string → boolean)
  • ~ category_id (database_data_type: decimal → int64)
  • ~ category_id (dotnet_data_type: decimal → int64)
  • ~ chunk_size (database_data_type: decimal → int64)
  • ~ chunk_size (dotnet_data_type: decimal → int64)
  • - details_auto_close_at
  • - details_auto_close_based_on_last_post
  • - details_auto_close_hours
  • ~ details_created_by_id (database_data_type: decimal → int64)
  • ~ details_created_by_id (dotnet_data_type: decimal → int64)
  • ~ details_last_poster_id (database_data_type: decimal → int64)
  • ~ details_last_poster_id (dotnet_data_type: decimal → int64)
  • ~ details_notification_level (database_data_type: decimal → int64)

96 modifications supplémentaires

Le paramètre « print » a été supprimé de Discourse.Topics.t_Post_streamPostsActions_summaryById

Un appel qui transmet ce paramètre échoue après la mise à niveau.

Que faire ?

Vérifiez les instructions, les Views et les scripts qui l'utilisent avant la mise à niveau.

  • peut interrompre une instruction
  • importance 4

  • ~ details_notification_level (dotnet_data_type: decimal → int64)
  • ~ draft_sequence (database_data_type: varchar2 → int64)
  • ~ draft_sequence (dotnet_data_type: string → int64)
  • - hidden_reason_id
  • ~ highest_post_number (database_data_type: decimal → int64)
  • ~ highest_post_number (dotnet_data_type: decimal → int64)
  • ~ id (database_data_type: decimal → int64)
  • ~ id (dotnet_data_type: decimal → int64)
  • ~ id_2 (database_data_type: decimal → int64)
  • ~ id_2 (dotnet_data_type: decimal → int64)
  • ~ incoming_link_count (database_data_type: decimal → int64)
  • ~ incoming_link_count (dotnet_data_type: decimal → int64)
  • ~ like_count (database_data_type: decimal → int64)
  • ~ like_count (dotnet_data_type: decimal → int64)
  • ~ participant_count (database_data_type: decimal → int64)
  • ~ participant_count (dotnet_data_type: decimal → int64)
  • - polls_poll_name
  • - polls_poll_status
  • - polls_poll_type
  • - polls_poll_voters
  • ~ post_number (database_data_type: decimal → int64)
  • ~ post_number (dotnet_data_type: decimal → int64)
  • ~ post_type (database_data_type: decimal → int64)
  • ~ post_type (dotnet_data_type: decimal → int64)
  • ~ posts_count (database_data_type: decimal → int64)
  • ~ posts_count (dotnet_data_type: decimal → int64)
  • - primary_group_flair_bg_color
  • - primary_group_flair_color
  • - primary_group_flair_url
  • ~ quote_count (database_data_type: decimal → int64)
  • ~ quote_count (dotnet_data_type: decimal → int64)
  • ~ reads (database_data_type: decimal → int64)
  • ~ reads (dotnet_data_type: decimal → int64)
  • ~ reply_count (database_data_type: decimal → int64)
  • ~ reply_count (dotnet_data_type: decimal → int64)
  • ~ reply_count_2 (database_data_type: decimal → int64)
  • ~ reply_count_2 (dotnet_data_type: decimal → int64)
  • ~ topic_id (database_data_type: decimal → int64)
  • ~ topic_id (dotnet_data_type: decimal → int64)
  • ~ trust_level (database_data_type: decimal → int64)
  • ~ trust_level (dotnet_data_type: decimal → int64)
  • ~ user_id (database_data_type: decimal → int64)
  • ~ user_id (dotnet_data_type: decimal → int64)
  • ~ user_id_2 (database_data_type: decimal → int64)
  • ~ user_id_2 (dotnet_data_type: decimal → int64)
  • ~ version (database_data_type: decimal → int64)
  • ~ version (dotnet_data_type: decimal → int64)
  • ~ views (database_data_type: decimal → int64)
  • ~ views (dotnet_data_type: decimal → int64)
  • ~ word_count (database_data_type: varchar2 → int64)
  • ~ word_count (dotnet_data_type: string → int64)
  • + bookmarked_2 (char)
  • + can_act (char)
  • + can_see_hidden_post (char)
  • + current_post_number (int64)
  • + details_can_archive_topic (char)
  • + details_can_banner_topic (char)
  • + details_can_close_topic (char)
  • + details_can_convert_topic (char)
  • + details_can_create_post (char)
  • + details_can_delete (char)
  • + details_can_edit (char)
  • + details_can_edit_staff_notes (char)
  • + details_can_invite_to (char)
  • + details_can_invite_via_email (char)
  • + details_can_moderate_category (char)
  • + details_can_move_posts (char)
  • + details_can_pin_unpin_topic (char)
  • + details_can_remove_allowed_users (char)
  • + details_can_remove_self_id (int64)
  • + details_can_reply_as_new_topic (char)
  • + details_can_review_topic (char)
  • + details_can_split_merge_topic (char)
  • + details_can_toggle_topic_visibility (char)
  • + details_created_by_name (varchar2)
  • + details_last_poster_name (varchar2)
  • + featured_link (varchar2)
  • + flair_bg_color (varchar2)
  • + flair_color (varchar2)
  • + flair_name (varchar2)
  • + flair_url (varchar2)
  • + has_deleted (char)
  • + id_3 (int64)
  • + image_url (varchar2)
  • + message_bus_last_id (int64)
  • + readers_count (int64)
  • + reviewable_id (int64)
  • + reviewable_score_count (int64)
  • + reviewable_score_pending_count (int64)
  • + show_read_indicator (char)
  • + slow_mode_enabled_until (varchar2)
  • + slow_mode_seconds (int64)
  • + tags_descriptions (varchar2)
  • + thumbnails (varchar2)
  • + topic_timer (varchar2)

Toutes les modifications apportées au chauffeur, 26.0 à 27.0