invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Posts: Discourse Posts

insert REST

  • Catalogus: Discourse
  • Schema: Posts
  • Label: Posts

Get a list of the latest posts across topics

Met insert kun je gegevens ophalen en wijzigen.

Samenvatting

Get a list of the latest posts across topics

API-bron

  • Eindpunt: /posts.json
  • Operatie: get /posts.json

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 243
Aantal rijen per minuut schrijven 219

Het resultaat kan op de client in de Cache worden opgeslagen.

Tabelkolommen

De kolommen van de tabel Posts worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
accepted_answer char Geaccepteerd antwoord filters on the platform, writable, accepted_answer
action_code varchar2 Actiecode filters on the platform, writable, action_code
admin char Administrator filters on the platform, writable, admin
avatar_template varchar2 Avatarsjabloon filters on the platform, writable, avatar_template
avg_time varchar2 itgen_dce_avg_time writable The JSON text of the nested object.
bookmarked char Bookmarked filters on the platform, writable, bookmarked
can_accept_answer char Antwoord kan worden geaccepteerd filters on the platform, writable, can_accept_answer
can_delete char Kan Verwijderen filters on the platform, writable, can_delete
can_edit char Kan Bewerken filters on the platform, writable, can_edit
can_recover varchar2 Kan Herstellen writable The JSON text of the nested object.
can_unaccept_answer char Kan 'Antwoord afwijzen' filters on the platform, writable, can_unaccept_answer
can_view_edit_history char Kan Bewerkingsgeschiedenis Bekijken filters on the platform, writable, can_view_edit_history
can_vote char Mag stemmen filters on the platform, writable, can_vote
can_wiki char Kan Wikify filters on the platform, writable, can_wiki
category_id decimal Categorie ID filters on the platform, writable, category_id
cooked varchar2 Cooked filters on the platform, writable, cooked
created_at varchar2 Aangemaakt op filters on the platform, writable, created_at
deleted_at varchar2 Verwijderd op writable The JSON text of the nested object.
display_username varchar2 Gebruikersnaam Weergeven filters on the platform, writable, display_username
edit_reason varchar2 Reden voor bewerking writable The JSON text of the nested object.
hidden char Hidden filters on the platform, writable, hidden
id decimal ID filters on the platform, writable, id
incoming_link_count decimal #Inkomende Links filters on the platform, writable, incoming_link_count
moderator char Moderator filters on the platform, writable, moderator
name varchar2 Name filters on the platform, writable, name
notice_type varchar2 Type kennisgeving filters on the platform, writable, notice.type
post_number decimal Postcode filters on the platform, writable, post_number
post_type decimal Berichttype filters on the platform, writable, 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 Naam van de basisschoolgroep writable The JSON text of the nested object.
quote_count decimal #Quotes filters on the platform, writable, quote_count
raw varchar2 Raw filters on the platform, writable, raw
readers_count int32 Aantal lezers filters on the platform, writable, readers_count
reads decimal #Reads filters on the platform, writable, reads
reply_count decimal #Replies filters on the platform, writable, reply_count
reply_to_post_number varchar2 Reageer op berichtnummer writable The JSON text of the nested object.
reply_to_user_avatar_template varchar2 Reactie op sjabloon voor gebruikersavatar filters on the platform, writable, reply_to_user.avatar_template
reply_to_user_username varchar2 Reageer op gebruiker Gebruikersnaam filters on the platform, writable, reply_to_user.username
reviewable_score_count int32 Aantal te beoordelen scores filters on the platform, writable, reviewable_score_count
reviewable_score_pending_count int32 Aantal in behandeling zijnde beoordelbare scores filters on the platform, writable, reviewable_score_pending_count
score decimal Score filters on the platform, writable, score
staff char Staff filters on the platform, writable, staff
static_doc char Statisch Document filters on the platform, writable, static_doc
title_is_group char Titel: Groep filters on the platform, writable, title_is_group
topic_html_title varchar2 Onderwerp HTML-titel filters on the platform, writable, topic_html_title
topic_id decimal Onderwerp ID filters on the platform, writable, topic_id
topic_slug varchar2 Onderwerp Slug filters on the platform, writable, topic_slug
topic_title varchar2 Onderwerptitel filters on the platform, writable, topic_title
trust_level decimal Vertrouwensniveau filters on the platform, writable, trust_level
updated_at varchar2 Bijgewerkt op filters on the platform, writable, updated_at
user_deleted char Gebruiker Verwijderd filters on the platform, writable, user_deleted
user_id decimal Gebruikers-ID filters on the platform, writable, user_id
user_title varchar2 Gebruikerstitel writable The JSON text of the nested object.
username varchar2 Gebruikersnaam filters on the platform, writable, username
version decimal Version filters on the platform, writable, version
via_email char Via e-mail filters on the platform, writable, via_email
wiki char Wiki filters on the platform, writable, wiki
yours char Yours filters on the platform, writable, yours

Toetsen

Key Column Verwijst naar Kind Description
Posts_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.

Geciteerd door

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

Wijzigingen in deze tabel, 26.0 tot 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)
  • ~ id (database_data_type: decimal → int64)
  • ~ id (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)
  • ~ post_type (dotnet_data_type: decimal → int64)
  • - primary_group_flair_bg_color
  • - primary_group_flair_color

42 meer wijzigingen

Discourse.Posts.Posts: wijzigingen in het type

Het type van Discourse.Posts.Posts verandert van tabel naar tabelfunctie.

Wat te doen

Controleer vóór de upgrade de Statements, Views en scripts die hiervan gebruikmaken.

  • kan een Statement onderbreken
  • table → tablefunction
  • belang 3
De parameter 'before' wordt toegevoegd aan Discourse.Posts.Posts

Optioneel.

  • belang 2

  • - primary_group_flair_url
  • ~ quote_count (database_data_type: decimal → int64)
  • ~ quote_count (dotnet_data_type: decimal → int64)
  • ~ readers_count (database_data_type: int32 → int64)
  • ~ readers_count (dotnet_data_type: int32 → 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)
  • ~ reviewable_score_count (database_data_type: int32 → int64)
  • ~ reviewable_score_count (dotnet_data_type: int32 → int64)
  • ~ reviewable_score_pending_count (database_data_type: int32 → int64)
  • ~ reviewable_score_pending_count (dotnet_data_type: int32 → 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)
  • + archetype (varchar2)
  • + auto_track (char)
  • + can_see_hidden_post (char)
  • + category (int32)
  • + embed_url (varchar2)
  • + excerpt (varchar2)
  • + external_id (varchar2)
  • + flair_bg_color (varchar2)
  • + flair_color (varchar2)
  • + flair_group_id (varchar2)
  • + flair_name (varchar2)
  • + flair_url (varchar2)
  • + post_url (varchar2)
  • + posts_count (int64)
  • + reviewable_id (varchar2)
  • + target_recipients (varchar2)
  • + title (varchar2)
  • + truncated (char)

Alle wisselingen van de Driver, 26.0 tot 27.0