Top_Topic_listTopics: Discourse Top Topics
read only REST
- Catalogus:
Discourse - Schema:
Topics - Label: Top Topics
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_listTopics 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, archetype |
||
archived |
char |
Archived | writable, archived |
||
bookmarked |
char |
Bookmarked | writable, bookmarked |
||
bumped |
char |
Bumped | writable, bumped |
||
bumped_ |
varchar2 |
Gestoten op | writable, bumped_ |
||
can_ |
char |
Kan Onderwerp Maken | writable, ::ancestor. |
||
can_ |
char |
Kan een antwoord geven | filters on the platform, writable, can_ |
||
can_ |
char |
Mag stemmen | filters on the platform, writable, can_ |
||
category_ |
decimal |
Categorie ID | writable, category_ |
||
closed |
char |
Closed | writable, closed |
||
created_ |
varchar2 |
Aangemaakt op | writable, created_ |
||
draft |
varchar2 |
Draft | writable | The JSON text of the nested object. | |
draft_ |
varchar2 |
Ontwerpsleutel | writable, ::ancestor. |
||
draft_ |
decimal |
Conceptreeks | writable, ::ancestor. |
||
fancy_ |
varchar2 |
Fancy Titel | writable, fancy_ |
||
for_ |
varchar2 |
Voor Periode | writable, ::ancestor. |
||
has_ |
char |
Antwoord is als juist gemarkeerd | filters on the platform, writable, has_ |
||
has_ |
char |
Heeft Samenvatting | writable, has_ |
||
highest_ |
decimal |
Hoogste Postnummer | writable, highest_ |
||
id |
decimal |
ID | writable, id |
||
image_ |
varchar2 |
Afbeelding URL | writable | The JSON text of the nested object. | |
last_ |
varchar2 |
Laatst Geplaatst op | writable, last_ |
||
last_ |
varchar2 |
Laatste Poster Gebruikersnaam | writable, last_ |
||
last_ |
decimal |
Nummer Laatst Gelezen Bericht | writable, last_ |
||
like_ |
decimal |
#Likes | writable, like_ |
||
liked |
char |
Liked | writable, liked |
||
new_ |
decimal |
Nieuwe Berichten | writable, new_ |
||
notification_ |
decimal |
Meldingsniveau | writable, notification_ |
||
per_ |
decimal |
Per Pagina | writable, ::ancestor. |
||
pinned |
char |
Pinned | writable, pinned |
||
pinned_ |
char |
Algemeen Vastgemaakt | writable, pinned_ |
||
posts_ |
decimal |
#Posts | writable, posts_ |
||
reply_ |
decimal |
#Replies | writable, reply_ |
||
slug |
varchar2 |
Slug | writable, slug |
||
title |
varchar2 |
Title | writable, title |
||
unpinned |
varchar2 |
Unpinned | writable | The JSON text of the nested object. | |
unread |
decimal |
Unread | writable, unread |
||
unseen |
char |
Unseen | writable, unseen |
||
user_ |
char |
Door gebruikers gekozen | filters on the platform, writable, user_ |
||
views |
decimal |
Views | writable, views |
||
visible |
char |
Visible | writable, visible |
||
vote_ |
int32 |
Aantal stemmen | filters on the platform, writable, vote_ |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Top_ |
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. |
Top_ |
last_ |
Top_Users. |
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
- Top_Topic_listTopicsPosters
id(Candidate)
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)
17 meer wijzigingen
Discourse.Topics.Top_Topic_listTopics: wijzigingen in het type
Het type van Discourse.Topics.Top_Topic_listTopics 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_listTopics
Optioneel.
- belang 2
De parameter ‘period’ is toegevoegd aan Discourse.Topics.Top_Topic_listTopics
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~views(database_data_type:decimal→int64)~views(dotnet_data_type:decimal→int64)+featured_link(varchar2)+op_like_count(int64)+unread_posts(int64)