invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Top_Topic_listTopicsPosters: Discourse Top Topic Posters

read only REST

  • Catalogus: Discourse
  • Schema: Topics
  • Label: Top Topic Posters

Get the top topics

Kan alleen gegevens ophalen.

Samenvatting

Get the top topics

API-bron

  • Eindpunt: /top.json
  • Operatie: get /top.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 Top_Topic_listTopicsPosters 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
archetype varchar2 Archetype writable, ::ancestor.archetype
archived char Archived writable, ::ancestor.archived
bookmarked char Bookmarked writable, ::ancestor.bookmarked
bumped char Bumped writable, ::ancestor.bumped
bumped_at varchar2 Gestoten op writable, ::ancestor.bumped_at
can_create_topic char Kan Onderwerp Maken writable, ::ancestor.::ancestor.can_create_topic
category_id decimal Categorie ID writable, ::ancestor.category_id
closed char Closed writable, ::ancestor.closed
created_at varchar2 Aangemaakt op writable, ::ancestor.created_at
description varchar2 Description writable, description
draft varchar2 Draft writable The JSON text of the nested object.
draft_key varchar2 Ontwerpsleutel writable, ::ancestor.::ancestor.draft_key
draft_sequence decimal Conceptreeks writable, ::ancestor.::ancestor.draft_sequence
extras varchar2 Extras writable, extras
fancy_title varchar2 Fancy Titel writable, ::ancestor.fancy_title
for_period varchar2 Voor Periode writable, ::ancestor.::ancestor.for_period
has_summary char Heeft Samenvatting writable, ::ancestor.has_summary
highest_post_number decimal Hoogste Postnummer writable, ::ancestor.highest_post_number
id decimal ID writable, ::ancestor.id
image_url varchar2 Afbeelding URL writable The JSON text of the nested object.
last_posted_at varchar2 Laatst Geplaatst op writable, ::ancestor.last_posted_at
last_poster_username varchar2 Laatste Poster Gebruikersnaam writable, ::ancestor.last_poster_username
last_read_post_number decimal Nummer Laatst Gelezen Bericht writable, ::ancestor.last_read_post_number
like_count decimal #Likes writable, ::ancestor.like_count
liked char Liked writable, ::ancestor.liked
new_posts decimal Nieuwe Berichten writable, ::ancestor.new_posts
notification_level decimal Meldingsniveau writable, ::ancestor.notification_level
per_page decimal Per Pagina writable, ::ancestor.::ancestor.per_page
pinned char Pinned writable, ::ancestor.pinned
pinned_globally char Algemeen Vastgemaakt writable, ::ancestor.pinned_globally
posts_count decimal #Posts writable, ::ancestor.posts_count
reply_count decimal #Replies writable, ::ancestor.reply_count
slug varchar2 Slug writable, ::ancestor.slug
title varchar2 Title writable, ::ancestor.title
unpinned varchar2 Unpinned writable The JSON text of the nested object.
unread decimal Unread writable, ::ancestor.unread
unseen char Unseen writable, ::ancestor.unseen
user_id decimal Gebruikers-ID writable, user_id
views decimal Views writable, ::ancestor.views
visible char Visible writable, ::ancestor.visible

Toetsen

Key Column Verwijst naar Kind Description
Top_Topic_listTopicsPosters_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.
Top_Topic_listTopicsPosters_id_cnd id Top_Topic_listTopics.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.
Top_Topic_listTopicsPosters_user_id_fk user_id Top_Users.id Key

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

  • ~ category_id (database_data_type: decimal → int64)
  • ~ category_id (dotnet_data_type: decimal → int64)
  • ~ draft_sequence (database_data_type: decimal → int64)
  • ~ draft_sequence (dotnet_data_type: decimal → int64)
  • ~ 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)
  • ~ last_read_post_number (database_data_type: decimal → int64)
  • ~ last_read_post_number (dotnet_data_type: decimal → int64)
  • ~ like_count (database_data_type: decimal → int64)
  • ~ like_count (dotnet_data_type: decimal → int64)
  • - new_posts
  • ~ notification_level (database_data_type: decimal → int64)
  • ~ notification_level (dotnet_data_type: decimal → int64)

20 meer wijzigingen

Discourse.Topics.Top_Topic_listTopicsPosters: wijzigingen in het type

Het type van Discourse.Topics.Top_Topic_listTopicsPosters 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 per_page is toegevoegd aan Discourse.Topics.Top_Topic_listTopicsPosters

Optioneel.

  • belang 2
De parameter ‘period’ is toegevoegd aan Discourse.Topics.Top_Topic_listTopicsPosters

Optioneel.

  • belang 2

  • ~ per_page (database_data_type: decimal → int64)
  • ~ per_page (dotnet_data_type: decimal → int64)
  • ~ posts_count (database_data_type: decimal → int64)
  • ~ posts_count (dotnet_data_type: decimal → int64)
  • ~ reply_count (database_data_type: decimal → int64)
  • ~ reply_count (dotnet_data_type: decimal → int64)
  • ~ unpinned (database_data_type: varchar2 → char)
  • ~ unpinned (dotnet_data_type: string → boolean)
  • - unread
  • ~ user_id (database_data_type: decimal → int64)
  • ~ user_id (dotnet_data_type: decimal → int64)
  • ~ views (database_data_type: decimal → int64)
  • ~ views (dotnet_data_type: decimal → int64)
  • + featured_link (varchar2)
  • + op_like_count (int64)
  • + primary_group_id (int64)
  • + unread_posts (int64)

Alle wisselingen van de Driver, 26.0 tot 27.0