invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

t_Post_streamPostsActions_summaryById: Discourse Topic Post Stream Posts Actions Summary by ID

read only REST

  • Catálogo: Discourse
  • Esquema: Topics
  • Label: Topic Post Stream Posts Actions Summary by ID

Get a single topic

Solo puede recuperar datos.

Resumen

Get a single topic

Fuente de la API

  • Punto final: /t/{id}.json
  • Operación: get /t/{id}.json

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 243
Escribir filas por minuto 219

El resultado se puede almacenar en la Caché del cliente.

Parámetros

Name Tipo de Datos Required Default Documentation
id ``
print `` Will return up to 1000 posts in a topic

Columnas de la Tabla

A continuación se muestran las columnas de la tabla t_Post_streamPostsActions_summaryById. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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 Plantilla de 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 Se puede eliminar writable, ::ancestor.can_delete
can_edit char Se puede editar writable, ::ancestor.can_edit
can_recover char Se puede recuperar writable, ::ancestor.can_recover
can_view_edit_history char Se puede ver el historial de modificaciones writable, ::ancestor.can_view_edit_history
can_wiki char ¿Se puede convertir en un artículo de la Wikipedia? writable, ::ancestor.can_wiki
category_id decimal ID de Categoría filters on the platform, writable, ::ancestor.::ancestor.::ancestor.category_id
chunk_size decimal Tamaño del fragmento 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 Creado en writable, ::ancestor.created_at
created_at_2 varchar2 Creado a las 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.created_at
deleted_at varchar2 Eliminado el writable The JSON text of the nested object.
deleted_at_2 varchar2 Eliminado a las 2 writable The JSON text of the nested object.
deleted_by varchar2 Eliminado por 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 Detalle: cierre automático en función de la última publicación 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 Detalle: Se puede marcar como tema destacado filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.can_flag_topic
details_created_by_avatar_template varchar2 Detalle creado con la plantilla «Avatar» filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.created_by.avatar_template
details_created_by_id decimal Detalle creado por ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.created_by.id
details_created_by_username varchar2 Detalle creado por [nombre de usuario] filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.created_by.username
details_last_poster_avatar_template varchar2 Detalles de la última plantilla de avatar de usuario filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.last_poster.avatar_template
details_last_poster_id decimal Detalle del último ID de usuario filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.last_poster.id
details_last_poster_username varchar2 Detalles del último usuario que publicó un mensaje: Nombre de usuario filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.last_poster.username
details_notification_level decimal Nivel de notificación detallado filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.notification_level
display_username varchar2 Mostrar nombre de usuario writable, ::ancestor.display_username
draft varchar2 Draft writable The JSON text of the nested object.
draft_key varchar2 Clave de Borrador filters on the platform, writable, ::ancestor.::ancestor.::ancestor.draft_key
draft_sequence varchar2 Secuencia de Borrador writable The JSON text of the nested object.
edit_reason varchar2 Motivo de la edición writable The JSON text of the nested object.
fancy_title varchar2 Título llamativo filters on the platform, writable, ::ancestor.::ancestor.::ancestor.fancy_title
has_summary char Resumen 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 Número de publicaciones más alto 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 #Enlaces entrantes writable, ::ancestor.incoming_link_count
last_posted_at varchar2 Última publicación el 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 Número de participantes 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 Fijado en filters on the platform, writable, ::ancestor.::ancestor.::ancestor.pinned_at
pinned_globally char Destacado a nivel mundial filters on the platform, writable, ::ancestor.::ancestor.::ancestor.pinned_globally
pinned_until varchar2 Fijado hasta el writable The JSON text of the nested object.
polls_poll_name varchar2 Nombre de la encuesta writable, ::ancestor.polls.poll.name
polls_poll_status varchar2 Estado de la encuesta writable, ::ancestor.polls.poll.status
polls_poll_type varchar2 Tipo de encuesta writable, ::ancestor.polls.poll.type
polls_poll_voters int64 Votantes de la encuesta writable, ::ancestor.polls.poll.voters
post_number decimal Número de publicación writable, ::ancestor.post_number
post_type decimal Tipo de entrada 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 Nombre del grupo 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 Número de respuestas: 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.reply_count
reply_to_post_number varchar2 Responder al mensaje número 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 ID del Tema writable, ::ancestor.topic_id
topic_slug varchar2 Slug del tema writable, ::ancestor.topic_slug
trust_level decimal Nivel de confianza writable, ::ancestor.trust_level
unpinned varchar2 Unpinned writable The JSON text of the nested object.
updated_at varchar2 Actualizado en writable, ::ancestor.updated_at
user_deleted char Usuario eliminado writable, ::ancestor.user_deleted
user_id decimal Identificación de Usuario writable, ::ancestor.user_id
user_id_2 decimal ID de usuario 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.user_id
user_title varchar2 Título de usuario writable The JSON text of the nested object.
username varchar2 Nombre de Usuario 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 Cuenta de Palabras writable The JSON text of the nested object.
yours char Yours writable, ::ancestor.yours

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

Modificaciones de esta tabla, De 26.0 a 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 cambios más

Se ha eliminado la impresión del parámetro de Discourse.Topics.t_Post_streamPostsActions_summaryById

Una llamada que pasa el parámetro falla tras la actualización.

Qué hacer

Comprueba las sentencias, Views y scripts que la utilicen antes de la actualización.

  • puede interrumpir una instrucción
  • importancia 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)

Todos los cambios del conductor, De 26.0 a 27.0