t_Post_streamPostsById: Discourse Topic Post Stream Posts by ID
read only REST
- Catalogus:
Discourse - Schema:
Topics - Label: Topic Post Stream Posts by ID
Get a single topic
Kan alleen gegevens ophalen.
Samenvatting
Get a single topic
API-bron
- Eindpunt:
/t/{id}.json - Operatie:
get /t/{id}.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.
Parameters
| Name | Datatype | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | |||
print |
`` | Will return up to 1000 posts in a topic |
Tabelkolommen
De kolommen van de tabel t_Post_streamPostsById 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 |
|---|---|---|---|---|---|
admin |
char |
Administrator | writable, admin |
||
archetype |
varchar2 |
Archetype | filters on the platform, writable, ::ancestor. |
||
archived |
char |
Archived | filters on the platform, writable, ::ancestor. |
||
avatar_ |
varchar2 |
Avatarsjabloon | writable, avatar_ |
||
avg_ |
varchar2 |
itgen_dce_avg_time | writable | The JSON text of the nested object. | |
bookmarked |
varchar2 |
Bookmarked | writable | The JSON text of the nested object. | |
can_ |
char |
Kan Verwijderen | writable, can_ |
||
can_ |
char |
Kan Bewerken | writable, can_ |
||
can_ |
char |
Kan Herstellen | writable, can_ |
||
can_ |
char |
Kan Bewerkingsgeschiedenis Bekijken | writable, can_ |
||
can_ |
char |
Kan Wikify | writable, can_ |
||
category_ |
decimal |
Categorie ID | filters on the platform, writable, ::ancestor. |
||
chunk_ |
decimal |
Blokformaat | filters on the platform, writable, ::ancestor. |
||
closed |
char |
Closed | filters on the platform, writable, ::ancestor. |
||
cooked |
varchar2 |
Cooked | writable, cooked |
||
created_ |
varchar2 |
Aangemaakt op | writable, created_ |
||
created_ |
varchar2 |
Gemaakt om 2 | filters on the platform, writable, ::ancestor. |
||
deleted_ |
varchar2 |
Verwijderd op | writable | The JSON text of the nested object. | |
deleted_ |
varchar2 |
Verwijderd om 2 uur | writable | The JSON text of the nested object. | |
deleted_ |
varchar2 |
Verwijderd door | 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 |
Detail Automatisch Sluiten op Laatste Bericht | filters on the platform, writable, ::ancestor. |
||
details_ |
varchar2 |
itgen_dce_details_auto_close_hours | writable | The JSON text of the nested object. | |
details_ |
char |
Detail kan Onderwerp Markeren | filters on the platform, writable, ::ancestor. |
||
details_ |
varchar2 |
Detail Gemaakt door Avatarsjabloon | filters on the platform, writable, ::ancestor. |
||
details_ |
decimal |
Detail Gemaakt door ID | filters on the platform, writable, ::ancestor. |
||
details_ |
varchar2 |
Detail Aangemaakt door Gebruiker | filters on the platform, writable, ::ancestor. |
||
details_ |
varchar2 |
Detail Laatste Poster Avatar-sjabloon | filters on the platform, writable, ::ancestor. |
||
details_ |
decimal |
Detail Laatste Poster ID | filters on the platform, writable, ::ancestor. |
||
details_ |
varchar2 |
Detail Laatste Poster Gebruikersnaam | filters on the platform, writable, ::ancestor. |
||
details_ |
decimal |
Detailmeldingsniveau | filters on the platform, writable, ::ancestor. |
||
display_ |
varchar2 |
Gebruikersnaam Weergeven | writable, display_ |
||
draft |
varchar2 |
Draft | writable | The JSON text of the nested object. | |
draft_ |
varchar2 |
Ontwerpsleutel | filters on the platform, writable, ::ancestor. |
||
draft_ |
varchar2 |
Conceptreeks | writable | The JSON text of the nested object. | |
edit_ |
varchar2 |
Reden voor bewerking | writable | The JSON text of the nested object. | |
fancy_ |
varchar2 |
Fancy Titel | filters on the platform, writable, ::ancestor. |
||
has_ |
char |
Heeft Samenvatting | filters on the platform, writable, ::ancestor. |
||
hidden |
char |
Hidden | writable, hidden |
||
hidden_ |
varchar2 |
itgen_dce_hidden_reason_id | writable | The JSON text of the nested object. | |
highest_ |
decimal |
Hoogste Postnummer | filters on the platform, writable, ::ancestor. |
||
id |
decimal |
ID | writable, id |
||
id_2 |
decimal |
ID 2 | filters on the platform, writable, ::ancestor. |
||
incoming_ |
decimal |
#Inkomende Links | writable, incoming_ |
||
last_ |
varchar2 |
Laatst Geplaatst op | writable | The JSON text of the nested object. | |
like_ |
decimal |
#Likes | filters on the platform, writable, ::ancestor. |
||
moderator |
char |
Moderator | writable, moderator |
||
name |
varchar2 |
Name | writable, name |
||
participant_ |
decimal |
Aantal Deelnemers | filters on the platform, writable, ::ancestor. |
||
pinned |
char |
Pinned | filters on the platform, writable, ::ancestor. |
||
pinned_ |
varchar2 |
Vastgemaakt op | filters on the platform, writable, ::ancestor. |
||
pinned_ |
char |
Algemeen Vastgemaakt | filters on the platform, writable, ::ancestor. |
||
pinned_ |
varchar2 |
Vastgezet tot | writable | The JSON text of the nested object. | |
polls_ |
varchar2 |
Stemmingnaam | writable, polls. |
||
polls_ |
varchar2 |
Stemmingstatus | writable, polls. |
||
polls_ |
varchar2 |
Stemmingsoort | writable, polls. |
||
polls_ |
int64 |
Stemming Stemmers | writable, polls. |
||
post_ |
decimal |
Postcode | writable, post_ |
||
post_ |
decimal |
Berichttype | writable, post_ |
||
posts_ |
decimal |
#Posts | 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 |
Naam van de basisschoolgroep | writable | The JSON text of the nested object. | |
quote_ |
decimal |
#Quotes | writable, quote_ |
||
read |
char |
Read | writable, read |
||
reads |
decimal |
#Reads | writable, reads |
||
reply_ |
decimal |
#Replies | writable, reply_ |
||
reply_ |
decimal |
Aantal Antwoorden 2 | filters on the platform, writable, ::ancestor. |
||
reply_ |
varchar2 |
Reageer op berichtnummer | writable | The JSON text of the nested object. | |
score |
decimal |
Score | writable, score |
||
slug |
varchar2 |
Slug | filters on the platform, writable, ::ancestor. |
||
staff |
char |
Staff | writable, staff |
||
title |
varchar2 |
Title | filters on the platform, writable, ::ancestor. |
||
topic_ |
decimal |
Onderwerp ID | writable, topic_ |
||
topic_ |
varchar2 |
Onderwerp Slug | writable, topic_ |
||
trust_ |
decimal |
Vertrouwensniveau | writable, trust_ |
||
unpinned |
varchar2 |
Unpinned | writable | The JSON text of the nested object. | |
updated_ |
varchar2 |
Bijgewerkt op | writable, updated_ |
||
user_ |
char |
Gebruiker Verwijderd | writable, user_ |
||
user_ |
decimal |
Gebruikers-ID | writable, user_ |
||
user_ |
decimal |
Gebruiker ID 2 | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
Gebruikerstitel | writable | The JSON text of the nested object. | |
username |
varchar2 |
Gebruikersnaam | writable, username |
||
version |
decimal |
Version | writable, version |
||
views |
decimal |
Views | filters on the platform, writable, ::ancestor. |
||
visible |
char |
Visible | filters on the platform, writable, ::ancestor. |
||
wiki |
char |
Wiki | writable, wiki |
||
word_ |
varchar2 |
Aantal Woorden | writable | The JSON text of the nested object. | |
yours |
char |
Yours | writable, yours |
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~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)
94 meer wijzigingen
De parameter ‘print’ is verwijderd uit Discourse.Topics.t_Post_streamPostsById
Een aanroep waarbij de parameter wordt doorgegeven, mislukt na de upgrade.
Wat te doen
Controleer vóór de upgrade de Statements, Views en scripts die hiervan gebruikmaken.
- kan een Statement onderbreken
- belang 4
~details_notification_level(dotnet_data_type:decimal→int64)~draft_sequence(database_data_type:varchar2→int64)~draft_sequence(dotnet_data_type:string→int64)-hidden_reason_id~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)~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)~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)-polls_poll_name-polls_poll_status-polls_poll_type-polls_poll_voters~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)~posts_count(database_data_type:decimal→int64)~posts_count(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)~reply_count_2(database_data_type:decimal→int64)~reply_count_2(dotnet_data_type:decimal→int64)~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)~user_id_2(database_data_type:decimal→int64)~user_id_2(dotnet_data_type:decimal→int64)~version(database_data_type:decimal→int64)~version(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)+bookmarked_2(char)+can_see_hidden_post(char)+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)+flair_bg_color(varchar2)+flair_color(varchar2)+flair_name(varchar2)+flair_url(varchar2)+has_deleted(char)+image_url(varchar2)+message_bus_last_id(int64)+readers_count(int64)+reviewable_id(int64)+reviewable_score_count(int64)+reviewable_score_pending_count(int64)+show_read_indicator(char)+slow_mode_enabled_until(varchar2)+slow_mode_seconds(int64)+tags_descriptions(varchar2)+thumbnails(varchar2)+topic_timer(varchar2)