invantive documentation
Invantive SupportforenAnmelden / Eintragen

t_Post_streamPostsById: Discourse Topic Post Stream Posts by ID

read only REST

  • Katalog: Discourse
  • Schema: Topics
  • Label: Topic Post Stream Posts 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 t_Post_streamPostsById 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
admin char Administrator writable, admin
archetype varchar2 Archetype filters on the platform, writable, ::ancestor.::ancestor.archetype
archived char Archived filters on the platform, writable, ::ancestor.::ancestor.archived
avatar_template varchar2 Avatar-Schablone writable, avatar_template
avg_time 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_delete char Kann löschen writable, can_delete
can_edit char Kann bearbeiten writable, can_edit
can_recover char Kann wiederhergestellt werden writable, can_recover
can_view_edit_history char View, Bearbeiten, Verlauf writable, can_view_edit_history
can_wiki char Kann man das in ein Wiki-Format umwandeln? writable, can_wiki
category_id decimal Kategorie-ID filters on the platform, writable, ::ancestor.::ancestor.category_id
chunk_size decimal Chunk-Größe filters on the platform, writable, ::ancestor.::ancestor.chunk_size
closed char Closed filters on the platform, writable, ::ancestor.::ancestor.closed
cooked varchar2 Cooked writable, cooked
created_at varchar2 Erstellt bei writable, created_at
created_at_2 varchar2 Erstellt um 2 Uhr filters on the platform, writable, ::ancestor.::ancestor.created_at
deleted_at varchar2 Gelöscht am writable The JSON text of the nested object.
deleted_at_2 varchar2 Um 2 gelöscht writable The JSON text of the nested object.
deleted_by varchar2 Gelöscht von writable The JSON text of the nested object.
details_auto_close_at varchar2 itgen_dce_details_auto_close_at writable The JSON text of the nested object.
details_auto_close_based_on_last_post char Automatisches Schließen des Themas basierend auf dem letzten Beitrag filters on the platform, writable, ::ancestor.::ancestor.details.auto_close_based_on_last_post
details_auto_close_hours varchar2 itgen_dce_details_auto_close_hours writable The JSON text of the nested object.
details_can_flag_topic char Detail kann Thema markieren filters on the platform, writable, ::ancestor.::ancestor.details.can_flag_topic
details_created_by_avatar_template varchar2 Detail, erstellt mit der Avatar-Schablone filters on the platform, writable, ::ancestor.::ancestor.details.created_by.avatar_template
details_created_by_id decimal Detail Erstellt von ID filters on the platform, writable, ::ancestor.::ancestor.details.created_by.id
details_created_by_username varchar2 Detail Erstellt von Benutzername filters on the platform, writable, ::ancestor.::ancestor.details.created_by.username
details_last_poster_avatar_template varchar2 Details zur Schablone für das Avatar des letzten Beitragsverfassers filters on the platform, writable, ::ancestor.::ancestor.details.last_poster.avatar_template
details_last_poster_id decimal Detail: ID des letzten Posters filters on the platform, writable, ::ancestor.::ancestor.details.last_poster.id
details_last_poster_username varchar2 Details Zuletzt gepostet Benutzername filters on the platform, writable, ::ancestor.::ancestor.details.last_poster.username
details_notification_level decimal Detaillierungsgrad der Benachrichtigung filters on the platform, writable, ::ancestor.::ancestor.details.notification_level
display_username varchar2 Benutzernamen anzeigen writable, display_username
draft varchar2 Draft writable The JSON text of the nested object.
draft_key varchar2 Entwurfsschlüssel filters on the platform, writable, ::ancestor.::ancestor.draft_key
draft_sequence varchar2 Entwurfssequenz writable The JSON text of the nested object.
edit_reason varchar2 Grund für die Bearbeitung writable The JSON text of the nested object.
fancy_title varchar2 Ausgefallener Titel filters on the platform, writable, ::ancestor.::ancestor.fancy_title
has_summary char Enthält eine Zusammenfassung filters on the platform, writable, ::ancestor.::ancestor.has_summary
hidden char Hidden writable, hidden
hidden_reason_id varchar2 itgen_dce_hidden_reason_id writable The JSON text of the nested object.
highest_post_number decimal Höchste Beitragszahl filters on the platform, writable, ::ancestor.::ancestor.highest_post_number
id decimal ID writable, id
id_2 decimal ID 2 filters on the platform, writable, ::ancestor.::ancestor.id
incoming_link_count decimal #Eingehende Links writable, incoming_link_count
last_posted_at varchar2 Zuletzt gepostet am writable The JSON text of the nested object.
like_count decimal #Likes filters on the platform, writable, ::ancestor.::ancestor.like_count
moderator char Moderator writable, moderator
name varchar2 Name writable, name
participant_count decimal Teilnehmerzahl filters on the platform, writable, ::ancestor.::ancestor.participant_count
pinned char Pinned filters on the platform, writable, ::ancestor.::ancestor.pinned
pinned_at varchar2 Gepinnt unter filters on the platform, writable, ::ancestor.::ancestor.pinned_at
pinned_globally char Weltweit angeheftet filters on the platform, writable, ::ancestor.::ancestor.pinned_globally
pinned_until varchar2 Gepinnt bis writable The JSON text of the nested object.
polls_poll_name varchar2 Name der Umfrage writable, polls.poll.name
polls_poll_status varchar2 Umfrage-Status writable, polls.poll.status
polls_poll_type varchar2 Umfragetyp writable, polls.poll.type
polls_poll_voters int64 Umfrageteilnehmer writable, polls.poll.voters
post_number decimal Beitragsnummer writable, post_number
post_type decimal Beitragstyp writable, post_type
posts_count decimal #Posts filters on the platform, writable, ::ancestor.::ancestor.posts_count
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 Name der Hauptgruppe writable The JSON text of the nested object.
quote_count decimal #Quotes writable, quote_count
read char Read writable, read
reads decimal #Reads writable, reads
reply_count decimal #Replies writable, reply_count
reply_count_2 decimal Anzahl der Antworten: 2 filters on the platform, writable, ::ancestor.::ancestor.reply_count
reply_to_post_number varchar2 Auf Beitrag Nummer antworten writable The JSON text of the nested object.
score decimal Score writable, score
slug varchar2 Slug filters on the platform, writable, ::ancestor.::ancestor.slug
staff char Staff writable, staff
title varchar2 Title filters on the platform, writable, ::ancestor.::ancestor.title
topic_id decimal Themen-ID writable, topic_id
topic_slug varchar2 Themen-Slug writable, topic_slug
trust_level decimal Vertrauensstufe writable, trust_level
unpinned varchar2 Unpinned writable The JSON text of the nested object.
updated_at varchar2 Aktualisiert am writable, updated_at
user_deleted char Benutzer wurde gelöscht writable, user_deleted
user_id decimal Benutzer-Kennung writable, user_id
user_id_2 decimal Benutzer-ID 2 filters on the platform, writable, ::ancestor.::ancestor.user_id
user_title varchar2 Titel des Benutzers writable The JSON text of the nested object.
username varchar2 Benutzername writable, username
version decimal Version writable, version
views decimal Views filters on the platform, writable, ::ancestor.::ancestor.views
visible char Visible filters on the platform, writable, ::ancestor.::ancestor.visible
wiki char Wiki writable, wiki
word_count varchar2 Wort-Anzahl writable The JSON text of the nested object.
yours char Yours writable, yours

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

  • - 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 weitere Änderungen

Der Parameter „print“ wurde aus „Discourse.Topics.t_Post_streamPostsById“ 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

  • ~ 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)

Alle Treiberwechsel, 26.0 bis 27.0