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

Posts_Latest_postsActions_summary: Discourse Posts Latest Post Actions Summary

read only REST

  • Catálogo: Discourse
  • Esquema: Posts
  • Label: Posts Latest Post Actions Summary

Get a list of the latest posts across topics

Solo puede recuperar datos.

Resumen

Get a list of the latest posts across topics

Fuente de la API

  • Punto final: /posts.json
  • Operación: get /posts.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.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla Posts_Latest_postsActions_summary. 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 filters on the platform, writable, ::ancestor.admin
avatar_template varchar2 Plantilla de avatar filters on the platform, writable, ::ancestor.avatar_template
avg_time varchar2 itgen_dce_avg_time writable The JSON text of the nested object.
can_act char Puede actuar writable, can_act
can_delete char Se puede eliminar filters on the platform, writable, ::ancestor.can_delete
can_edit char Se puede editar filters on the platform, writable, ::ancestor.can_edit
can_recover varchar2 Se puede recuperar writable The JSON text of the nested object.
can_view_edit_history char Se puede ver el historial de modificaciones filters on the platform, writable, ::ancestor.can_view_edit_history
can_wiki char ¿Se puede convertir en un artículo de la Wikipedia? filters on the platform, writable, ::ancestor.can_wiki
category_id decimal ID de Categoría filters on the platform, writable, ::ancestor.category_id
cooked varchar2 Cooked filters on the platform, writable, ::ancestor.cooked
count int32 Count filters on the platform, writable, count
created_at varchar2 Creado en filters on the platform, writable, ::ancestor.created_at
deleted_at varchar2 Eliminado el writable The JSON text of the nested object.
display_username varchar2 Mostrar nombre de usuario filters on the platform, writable, ::ancestor.display_username
edit_reason varchar2 Motivo de la edición writable The JSON text of the nested object.
hidden char Hidden writable, hidden
hidden_2 char itgen_dce_hidden_2 filters on the platform, writable, ::ancestor.hidden
id decimal ID writable, id
id_2 decimal ID 2 filters on the platform, writable, ::ancestor.id
incoming_link_count decimal #Enlaces entrantes filters on the platform, writable, ::ancestor.incoming_link_count
moderator char Moderator filters on the platform, writable, ::ancestor.moderator
name varchar2 Name filters on the platform, writable, ::ancestor.name
post_number decimal Número de publicación filters on the platform, writable, ::ancestor.post_number
post_type decimal Tipo de entrada filters on the platform, writable, ::ancestor.post_type
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 filters on the platform, writable, ::ancestor.quote_count
raw varchar2 Raw filters on the platform, writable, ::ancestor.raw
reads decimal #Reads filters on the platform, writable, ::ancestor.reads
reply_count decimal #Replies filters on the platform, writable, ::ancestor.reply_count
reply_to_post_number varchar2 Responder al mensaje número writable The JSON text of the nested object.
score decimal Score filters on the platform, writable, ::ancestor.score
staff char Staff filters on the platform, writable, ::ancestor.staff
static_doc char Documentación estática filters on the platform, writable, ::ancestor.static_doc
topic_html_title varchar2 Título HTML del tema filters on the platform, writable, ::ancestor.topic_html_title
topic_id decimal ID del Tema filters on the platform, writable, ::ancestor.topic_id
topic_slug varchar2 Slug del tema filters on the platform, writable, ::ancestor.topic_slug
topic_title varchar2 Título del tema filters on the platform, writable, ::ancestor.topic_title
trust_level decimal Nivel de confianza filters on the platform, writable, ::ancestor.trust_level
updated_at varchar2 Actualizado en filters on the platform, writable, ::ancestor.updated_at
user_deleted char Usuario eliminado filters on the platform, writable, ::ancestor.user_deleted
user_id decimal Identificación de Usuario filters on the platform, writable, ::ancestor.user_id
user_title varchar2 Título de usuario writable The JSON text of the nested object.
username varchar2 Nombre de Usuario filters on the platform, writable, ::ancestor.username
version decimal Version filters on the platform, writable, ::ancestor.version
wiki char Wiki filters on the platform, writable, ::ancestor.wiki
yours char Yours filters on the platform, writable, ::ancestor.yours

Teclas

Key Column Se refiere a Kind Description
Posts_Latest_postsActions_summary_category_id_cnd category_id Categories.id Candidate Not stated by Discourse; found on the data of the smoke forum on 2026-10-31, where every filled value is in the referenced table.
Posts_Latest_postsActions_summary_id_2_cnd id_2 Posts.id Candidate Not stated by Discourse; found on the data of the smoke forum on 2026-10-31, where every filled value is in the referenced table.

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
  • ~ can_recover (database_data_type: varchar2 → char)
  • ~ can_recover (dotnet_data_type: string → boolean)
  • ~ category_id (database_data_type: decimal → int64)
  • ~ category_id (dotnet_data_type: decimal → int64)
  • - hidden_2
  • ~ 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)
  • ~ post_number (database_data_type: decimal → int64)
  • ~ post_number (dotnet_data_type: decimal → int64)
  • ~ post_type (database_data_type: decimal → int64)

36 cambios más

Discourse.Posts.Posts_Latest_postsActions_summary: cambios de tipo

El tipo de «Discourse.Posts.Posts_Latest_postsActions_summary» cambia de «Tabla» a «función de tabla».

Qué hacer

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

  • puede interrumpir una instrucción
  • table → tablefunction
  • importancia 3
El parámetro anterior se añade a Discourse.Posts.Posts_Latest_postsActions_summary

Opcional.

  • importancia 2

  • ~ post_type (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)
  • - static_doc
  • ~ 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)
  • ~ version (database_data_type: decimal → int64)
  • ~ version (dotnet_data_type: decimal → int64)
  • + bookmarked (char)
  • + can_see_hidden_post (char)
  • + excerpt (varchar2)
  • + flair_bg_color (varchar2)
  • + flair_color (varchar2)
  • + flair_group_id (varchar2)
  • + flair_name (varchar2)
  • + flair_url (varchar2)
  • + post_url (varchar2)
  • + posts_count (int64)
  • + readers_count (int64)
  • + reviewable_id (varchar2)
  • + reviewable_score_count (int64)
  • + reviewable_score_pending_count (int64)
  • + truncated (char)

Todos los cambios del conductor, De 26.0 a 27.0