tById: Discourse Topic by ID
read only REST
- Katalog:
Discourse - Schema:
Topics - Label: Topic by ID
Get a single topic
Es können nur Daten abgerufen werden.
Zusammenfassung
Get a single topic
API-Quelle
- Endpunkt:
/t/{id}.json - Operation:
get /t/{id}.json
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Durchschnittliche Zugriffsverzögerung (ms) | 243 |
| Zeilen pro Minute schreiben | 219 |
Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.
Parameter
| Name | Datentyp | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | |||
print |
`` | Will return up to 1000 posts in a topic |
Tabellenspalten
Die Spalten der Tabelle tById sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
archetype |
varchar2 |
Archetype | filters on the platform, writable, archetype |
||
archived |
char |
Archived | filters on the platform, writable, archived |
||
bookmarked |
varchar2 |
Bookmarked | writable | The JSON text of the nested object. | |
category_ |
decimal |
Kategorie-ID | filters on the platform, writable, category_ |
||
chunk_ |
decimal |
Chunk-Größe | filters on the platform, writable, chunk_ |
||
closed |
char |
Closed | filters on the platform, writable, closed |
||
created_ |
varchar2 |
Erstellt bei | filters on the platform, writable, created_ |
||
deleted_ |
varchar2 |
Gelöscht am | writable | The JSON text of the nested object. | |
deleted_ |
varchar2 |
Gelöscht von | writable | The JSON text of the nested object. | |
details_ |
varchar2 |
itgen_dce_details_auto_close_at | writable | The JSON text of the nested object. | |
details_ |
char |
Automatisches Schließen des Themas basierend auf dem letzten Beitrag | filters on the platform, writable, details. |
||
details_ |
varchar2 |
itgen_dce_details_auto_close_hours | writable | The JSON text of the nested object. | |
details_ |
char |
Detail kann Thema markieren | filters on the platform, writable, details. |
||
details_ |
varchar2 |
Detail, erstellt mit der Avatar-Schablone | filters on the platform, writable, details. |
||
details_ |
decimal |
Detail Erstellt von ID | filters on the platform, writable, details. |
||
details_ |
varchar2 |
Detail Erstellt von Benutzername | filters on the platform, writable, details. |
||
details_ |
varchar2 |
Details zur Schablone für das Avatar des letzten Beitragsverfassers | filters on the platform, writable, details. |
||
details_ |
decimal |
Detail: ID des letzten Posters | filters on the platform, writable, details. |
||
details_ |
varchar2 |
Details Zuletzt gepostet Benutzername | filters on the platform, writable, details. |
||
details_ |
decimal |
Detaillierungsgrad der Benachrichtigung | filters on the platform, writable, details. |
||
draft |
varchar2 |
Draft | writable | The JSON text of the nested object. | |
draft_ |
varchar2 |
Entwurfsschlüssel | filters on the platform, writable, draft_ |
||
draft_ |
varchar2 |
Entwurfssequenz | writable | The JSON text of the nested object. | |
fancy_ |
varchar2 |
Ausgefallener Titel | filters on the platform, writable, fancy_ |
||
has_ |
char |
Enthält eine Zusammenfassung | filters on the platform, writable, has_ |
||
highest_ |
decimal |
Höchste Beitragszahl | filters on the platform, writable, highest_ |
||
id |
decimal |
ID | filters on the platform, writable, id |
||
last_ |
varchar2 |
Zuletzt gepostet am | writable | The JSON text of the nested object. | |
like_ |
decimal |
#Likes | filters on the platform, writable, like_ |
||
participant_ |
decimal |
Teilnehmerzahl | filters on the platform, writable, participant_ |
||
pinned |
char |
Pinned | filters on the platform, writable, pinned |
||
pinned_ |
varchar2 |
Gepinnt unter | filters on the platform, writable, pinned_ |
||
pinned_ |
char |
Weltweit angeheftet | filters on the platform, writable, pinned_ |
||
pinned_ |
varchar2 |
Gepinnt bis | writable | The JSON text of the nested object. | |
posts_ |
decimal |
#Posts | filters on the platform, writable, posts_ |
||
reply_ |
decimal |
#Replies | filters on the platform, writable, reply_ |
||
slug |
varchar2 |
Slug | filters on the platform, writable, slug |
||
title |
varchar2 |
Title | filters on the platform, writable, title |
||
unpinned |
varchar2 |
Unpinned | writable | The JSON text of the nested object. | |
user_ |
decimal |
Benutzer-Kennung | filters on the platform, writable, user_ |
||
views |
decimal |
Views | filters on the platform, writable, views |
||
visible |
char |
Visible | filters on the platform, writable, visible |
||
word_ |
varchar2 |
Wort-Anzahl | writable | The JSON text of the nested object. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:
Änderungen an dieser Tabelle, 26.0 bis 27.0
~bookmarked(database_data_type:varchar2→char)~bookmarked(dotnet_data_type:string→boolean)~category_id(database_data_type:decimal→int64)~category_id(dotnet_data_type:decimal→int64)~chunk_size(database_data_type:decimal→int64)~chunk_size(dotnet_data_type:decimal→int64)-details_auto_close_at-details_auto_close_based_on_last_post-details_auto_close_hours~details_created_by_id(database_data_type:decimal→int64)~details_created_by_id(dotnet_data_type:decimal→int64)~details_last_poster_id(database_data_type:decimal→int64)~details_last_poster_id(dotnet_data_type:decimal→int64)~details_notification_level(database_data_type:decimal→int64)~details_notification_level(dotnet_data_type:decimal→int64)
53 weitere Änderungen
Die Parameterausgabe wurde aus „Discourse.Topics.tById“ entfernt.
Ein Aufruf, der diesen Parameter übergibt, schlägt nach dem Upgrade fehl.
Was ist zu tun?
Überprüfen Sie vor dem Upgrade alle Statements, Views und Skripte, die diese Spalte verwenden.
- kann ein Statement unterbrechen
- Bedeutung 4
~draft_sequence(database_data_type:varchar2→int64)~draft_sequence(dotnet_data_type:string→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)~like_count(database_data_type:decimal→int64)~like_count(dotnet_data_type:decimal→int64)~participant_count(database_data_type:decimal→int64)~participant_count(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)~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)~word_count(database_data_type:varchar2→int64)~word_count(dotnet_data_type:string→int64)+current_post_number(int64)+details_can_archive_topic(char)+details_can_banner_topic(char)+details_can_close_topic(char)+details_can_convert_topic(char)+details_can_create_post(char)+details_can_delete(char)+details_can_edit(char)+details_can_edit_staff_notes(char)+details_can_invite_to(char)+details_can_invite_via_email(char)+details_can_moderate_category(char)+details_can_move_posts(char)+details_can_pin_unpin_topic(char)+details_can_remove_allowed_users(char)+details_can_remove_self_id(int64)+details_can_reply_as_new_topic(char)+details_can_review_topic(char)+details_can_split_merge_topic(char)+details_can_toggle_topic_visibility(char)+details_created_by_name(varchar2)+details_last_poster_name(varchar2)+featured_link(varchar2)+has_deleted(char)+image_url(varchar2)+message_bus_last_id(int64)+show_read_indicator(char)+slow_mode_enabled_until(varchar2)+slow_mode_seconds(int64)+tags_descriptions(varchar2)+thumbnails(varchar2)+topic_timer(varchar2)