invantive documentation
Invantive SupportforenAnmelden / Eintragen

t_Post_streamPostsActions_summaryById: Discourse Topic Post Stream Posts Actions Summary by ID

read only REST

  • Katalog: Discourse
  • Schema: Topics
  • Label: Topic Post Stream Posts Actions Summary 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_streamPostsActions_summaryById 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, ::ancestor.admin
archetype varchar2 Archetype filters on the platform, writable, ::ancestor.::ancestor.::ancestor.archetype
archived char Archived filters on the platform, writable, ::ancestor.::ancestor.::ancestor.archived
avatar_template varchar2 Avatar-Schablone writable, ::ancestor.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, ::ancestor.can_delete
can_edit char Kann bearbeiten writable, ::ancestor.can_edit
can_recover char Kann wiederhergestellt werden writable, ::ancestor.can_recover
can_view_edit_history char View, Bearbeiten, Verlauf writable, ::ancestor.can_view_edit_history
can_wiki char Kann man das in ein Wiki-Format umwandeln? writable, ::ancestor.can_wiki
category_id decimal Kategorie-ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.category_id
chunk_size decimal Chunk-Größe filters on the platform, writable, ::ancestor.::ancestor.::ancestor.chunk_size
closed char Closed filters on the platform, writable, ::ancestor.::ancestor.::ancestor.closed
cooked varchar2 Cooked writable, ::ancestor.cooked
created_at varchar2 Erstellt bei writable, ::ancestor.created_at
created_at_2 varchar2 Erstellt um 2 Uhr filters on the platform, writable, ::ancestor.::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.::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.::ancestor.details.can_flag_topic
details_created_by_avatar_template varchar2 Detail, erstellt mit der Avatar-Schablone filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.created_by.avatar_template
details_created_by_id decimal Detail Erstellt von ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.created_by.id
details_created_by_username varchar2 Detail Erstellt von Benutzername filters on the platform, writable, ::ancestor.::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.::ancestor.details.last_poster.avatar_template
details_last_poster_id decimal Detail: ID des letzten Posters filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.last_poster.id
details_last_poster_username varchar2 Details Zuletzt gepostet Benutzername filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.last_poster.username
details_notification_level decimal Detaillierungsgrad der Benachrichtigung filters on the platform, writable, ::ancestor.::ancestor.::ancestor.details.notification_level
display_username varchar2 Benutzernamen anzeigen writable, ::ancestor.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.::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.::ancestor.fancy_title
has_summary char Enthält eine Zusammenfassung filters on the platform, writable, ::ancestor.::ancestor.::ancestor.has_summary
hidden char Hidden writable, ::ancestor.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.::ancestor.highest_post_number
id decimal ID writable, ::ancestor.id
id_2 decimal ID 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.id
incoming_link_count decimal #Eingehende Links writable, ::ancestor.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.::ancestor.like_count
moderator char Moderator writable, ::ancestor.moderator
name varchar2 Name writable, ::ancestor.name
participant_count decimal Teilnehmerzahl filters on the platform, writable, ::ancestor.::ancestor.::ancestor.participant_count
pinned char Pinned filters on the platform, writable, ::ancestor.::ancestor.::ancestor.pinned
pinned_at varchar2 Gepinnt unter filters on the platform, writable, ::ancestor.::ancestor.::ancestor.pinned_at
pinned_globally char Weltweit angeheftet filters on the platform, writable, ::ancestor.::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, ::ancestor.polls.poll.name
polls_poll_status varchar2 Umfrage-Status writable, ::ancestor.polls.poll.status
polls_poll_type varchar2 Umfragetyp writable, ::ancestor.polls.poll.type
polls_poll_voters int64 Umfrageteilnehmer writable, ::ancestor.polls.poll.voters
post_number decimal Beitragsnummer writable, ::ancestor.post_number
post_type decimal Beitragstyp writable, ::ancestor.post_type
posts_count decimal #Posts filters on the platform, writable, ::ancestor.::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, ::ancestor.quote_count
read char Read writable, ::ancestor.read
reads decimal #Reads writable, ::ancestor.reads
reply_count decimal #Replies writable, ::ancestor.reply_count
reply_count_2 decimal Anzahl der Antworten: 2 filters on the platform, writable, ::ancestor.::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, ::ancestor.score
slug varchar2 Slug filters on the platform, writable, ::ancestor.::ancestor.::ancestor.slug
staff char Staff writable, ::ancestor.staff
title varchar2 Title filters on the platform, writable, ::ancestor.::ancestor.::ancestor.title
topic_id decimal Themen-ID writable, ::ancestor.topic_id
topic_slug varchar2 Themen-Slug writable, ::ancestor.topic_slug
trust_level decimal Vertrauensstufe writable, ::ancestor.trust_level
unpinned varchar2 Unpinned writable The JSON text of the nested object.
updated_at varchar2 Aktualisiert am writable, ::ancestor.updated_at
user_deleted char Benutzer wurde gelöscht writable, ::ancestor.user_deleted
user_id decimal Benutzer-Kennung writable, ::ancestor.user_id
user_id_2 decimal Benutzer-ID 2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.user_id
user_title varchar2 Titel des Benutzers writable The JSON text of the nested object.
username varchar2 Benutzername writable, ::ancestor.username
version decimal Version writable, ::ancestor.version
views decimal Views filters on the platform, writable, ::ancestor.::ancestor.::ancestor.views
visible char Visible filters on the platform, writable, ::ancestor.::ancestor.::ancestor.visible
wiki char Wiki writable, ::ancestor.wiki
word_count varchar2 Wort-Anzahl writable The JSON text of the nested object.
yours char Yours writable, ::ancestor.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)

96 weitere Änderungen

Der Parameter „print“ wurde aus „Discourse.Topics.t_Post_streamPostsActions_summaryById“ 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_act (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)
  • + id_3 (int64)
  • + 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