Posts_Latest_postsActions_summary: Discourse Posts Latest Post Actions Summary
read only REST
- Catalogo:
Discourse - Schema:
Posts - Label: Posts Latest Post Actions Summary
Get a list of the latest posts across topics
È possibile solo recuperare i dati.
Riepilogo
Get a list of the latest posts across topics
Codice sorgente dell'API
- Punto finale:
/posts.json - Operazione:
get /posts.json
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 243 |
| Scrittura di righe al minuto | 219 |
Il risultato può essere memorizzato nella memoria cache sul client.
Colonne della tabella
Di seguito sono riportate le colonne della tabella Posts_Latest_postsActions_summary. 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 |
|---|---|---|---|---|---|
admin |
char |
Administrator | filters on the platform, writable, ::ancestor. |
||
avatar_ |
varchar2 |
Modello per avatar | filters on the platform, writable, ::ancestor. |
||
avg_ |
varchar2 |
itgen_dce_avg_time | writable | The JSON text of the nested object. | |
can_ |
char |
Può agire | writable, can_ |
||
can_ |
char |
Può eliminare | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
È possibile modificare | filters on the platform, writable, ::ancestor. |
||
can_ |
varchar2 |
È possibile recuperare | writable | The JSON text of the nested object. | |
can_ |
char |
Può visualizzare la cronologia delle modifiche | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
È possibile convertire in formato wiki | filters on the platform, writable, ::ancestor. |
||
category_ |
decimal |
ID categoria | filters on the platform, writable, ::ancestor. |
||
cooked |
varchar2 |
Cooked | filters on the platform, writable, ::ancestor. |
||
count |
int32 |
Count | filters on the platform, writable, count |
||
created_ |
varchar2 |
Creato il | filters on the platform, writable, ::ancestor. |
||
deleted_ |
varchar2 |
Eliminato alle | writable | The JSON text of the nested object. | |
display_ |
varchar2 |
Visualizza nome utente | filters on the platform, writable, ::ancestor. |
||
edit_ |
varchar2 |
Motivo della modifica | writable | The JSON text of the nested object. | |
hidden |
char |
Hidden | writable, hidden |
||
hidden_ |
char |
itgen_dce_hidden_2 | filters on the platform, writable, ::ancestor. |
||
id |
decimal |
ID | writable, id |
||
id_2 |
decimal |
ID 2 | filters on the platform, writable, ::ancestor. |
||
incoming_ |
decimal |
#Link in entrata | filters on the platform, writable, ::ancestor. |
||
moderator |
char |
Moderator | filters on the platform, writable, ::ancestor. |
||
name |
varchar2 |
Name | filters on the platform, writable, ::ancestor. |
||
post_ |
decimal |
Numero del post | filters on the platform, writable, ::ancestor. |
||
post_ |
decimal |
Tipo di post | filters on the platform, writable, ::ancestor. |
||
primary_ |
varchar2 |
itgen_dce_primary_group_flair_bg_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_url | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
Nome del gruppo primario | writable | The JSON text of the nested object. | |
quote_ |
decimal |
#Quotes | filters on the platform, writable, ::ancestor. |
||
raw |
varchar2 |
Raw | filters on the platform, writable, ::ancestor. |
||
reads |
decimal |
#Reads | filters on the platform, writable, ::ancestor. |
||
reply_ |
decimal |
#Replies | filters on the platform, writable, ::ancestor. |
||
reply_ |
varchar2 |
Rispondi al post numero | writable | The JSON text of the nested object. | |
score |
decimal |
Score | filters on the platform, writable, ::ancestor. |
||
staff |
char |
Staff | filters on the platform, writable, ::ancestor. |
||
static_ |
char |
Documento statico | filters on the platform, writable, ::ancestor. |
||
topic_ |
varchar2 |
Titolo HTML dell'argomento | filters on the platform, writable, ::ancestor. |
||
topic_ |
decimal |
ID argomento | filters on the platform, writable, ::ancestor. |
||
topic_ |
varchar2 |
Slug dell'argomento | filters on the platform, writable, ::ancestor. |
||
topic_ |
varchar2 |
Titolo dell'argomento | filters on the platform, writable, ::ancestor. |
||
trust_ |
decimal |
Livello di fiducia | filters on the platform, writable, ::ancestor. |
||
updated_ |
varchar2 |
Aggiornato il | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
Utente eliminato | filters on the platform, writable, ::ancestor. |
||
user_ |
decimal |
ID Utente | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
Titolo utente | writable | The JSON text of the nested object. | |
username |
varchar2 |
Nome Utente | filters on the platform, writable, ::ancestor. |
||
version |
decimal |
Version | filters on the platform, writable, ::ancestor. |
||
wiki |
char |
Wiki | filters on the platform, writable, ::ancestor. |
||
yours |
char |
Yours | filters on the platform, writable, ::ancestor. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Posts_ |
category_ |
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_ |
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. |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:
Modifiche apportate a questa tabella, da 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 ulteriori modifiche
Discourse.Posts.Posts_Latest_postsActions_summary: modifiche al tipo
Il tipo di Discourse.Posts.Posts_Latest_postsActions_summary cambia da tabella a tabella.
Cosa fare
Verificare le istruzioni, le Views e gli script che la utilizzano prima dell’aggiornamento.
- può interrompere un'istruzione
table→tablefunction- importanza 3
Il parametro "before" viene aggiunto a Discourse.Posts.Posts_Latest_postsActions_summary
Facoltativo.
- importanza 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)