invantive documentation
Invantive SupportforenAnmelden / Eintragen

t_DetailsParticipantsById: Discourse Topic Details Participants by ID

read only REST

  • Katalog: Discourse
  • Schema: Topics
  • Label: Topic Details Participants 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_DetailsParticipantsById 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, ::ancestor.::ancestor.archetype
archived char Archived filters on the platform, writable, ::ancestor.::ancestor.archived
auto_close_at varchar2 itgen_dce_auto_close_at writable The JSON text of the nested object.
auto_close_based_on_last_post char Automatisches Schließen basierend auf dem letzten Beitrag writable, ::ancestor.auto_close_based_on_last_post
auto_close_hours varchar2 Öffnungszeiten mit automatischer Schließung writable The JSON text of the nested object.
avatar_template varchar2 Avatar-Schablone writable, avatar_template
bookmarked varchar2 Bookmarked writable The JSON text of the nested object.
can_flag_topic char Thema als „Flag“ markieren writable, ::ancestor.can_flag_topic
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
created_at varchar2 Erstellt bei filters on the platform, writable, ::ancestor.::ancestor.created_at
created_by_avatar_template varchar2 Erstellt mit der Avatar-Schablone writable, ::ancestor.created_by.avatar_template
created_by_id decimal Erstellt von ID writable, ::ancestor.created_by.id
created_by_username varchar2 Erstellt von Benutzername writable, ::ancestor.created_by.username
deleted_at varchar2 Gelöscht am writable The JSON text of the nested object.
deleted_by varchar2 Gelöscht von writable The JSON text of the nested object.
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.
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
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
last_posted_at varchar2 Zuletzt gepostet am writable The JSON text of the nested object.
last_poster_avatar_template varchar2 Schablone für das Avatar des letzten Beitrags writable, ::ancestor.last_poster.avatar_template
last_poster_id decimal ID des letzten Beitrags writable, ::ancestor.last_poster.id
last_poster_username varchar2 Benutzername des letzten Verfassers writable, ::ancestor.last_poster.username
like_count decimal #Likes filters on the platform, writable, ::ancestor.::ancestor.like_count
notification_level decimal Benachrichtigungsstufe writable, ::ancestor.notification_level
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.
post_count decimal #Posts writable, post_count
posts_count decimal #Posts filters on the platform, writable, ::ancestor.::ancestor.posts_count
reply_count decimal #Replies filters on the platform, writable, ::ancestor.::ancestor.reply_count
slug varchar2 Slug filters on the platform, writable, ::ancestor.::ancestor.slug
title varchar2 Title filters on the platform, writable, ::ancestor.::ancestor.title
unpinned varchar2 Unpinned writable The JSON text of the nested object.
user_id decimal Benutzer-Kennung filters on the platform, writable, ::ancestor.::ancestor.user_id
username varchar2 Benutzername writable, username
views decimal Views filters on the platform, writable, ::ancestor.::ancestor.views
visible char Visible filters on the platform, writable, ::ancestor.::ancestor.visible
word_count 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

  • - auto_close_at
  • - auto_close_based_on_last_post
  • - auto_close_hours
  • ~ 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)
  • ~ created_by_id (database_data_type: decimal → int64)
  • ~ created_by_id (dotnet_data_type: decimal → int64)
  • ~ 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)

67 weitere Änderungen

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

  • ~ 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)
  • ~ last_poster_id (database_data_type: decimal → int64)
  • ~ last_poster_id (dotnet_data_type: decimal → int64)
  • ~ like_count (database_data_type: decimal → int64)
  • ~ like_count (dotnet_data_type: decimal → int64)
  • ~ notification_level (database_data_type: decimal → int64)
  • ~ notification_level (dotnet_data_type: decimal → int64)
  • ~ participant_count (database_data_type: decimal → int64)
  • ~ participant_count (dotnet_data_type: decimal → int64)
  • ~ post_count (database_data_type: decimal → int64)
  • ~ post_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)
  • + admin (char)
  • + can_archive_topic (char)
  • + can_banner_topic (char)
  • + can_close_topic (char)
  • + can_convert_topic (char)
  • + can_create_post (char)
  • + can_delete (char)
  • + can_edit (char)
  • + can_edit_staff_notes (char)
  • + can_invite_to (char)
  • + can_invite_via_email (char)
  • + can_moderate_category (char)
  • + can_move_posts (char)
  • + can_pin_unpin_topic (char)
  • + can_remove_allowed_users (char)
  • + can_remove_self_id (int64)
  • + can_reply_as_new_topic (char)
  • + can_review_topic (char)
  • + can_split_merge_topic (char)
  • + can_toggle_topic_visibility (char)
  • + created_by_name (varchar2)
  • + current_post_number (int64)
  • + featured_link (varchar2)
  • + flair_bg_color (varchar2)
  • + flair_color (varchar2)
  • + flair_group_id (int64)
  • + flair_name (varchar2)
  • + flair_url (varchar2)
  • + has_deleted (char)
  • + image_url (varchar2)
  • + last_poster_name (varchar2)
  • + message_bus_last_id (int64)
  • + moderator (char)
  • + name (varchar2)
  • + primary_group_name (varchar2)
  • + show_read_indicator (char)
  • + slow_mode_enabled_until (varchar2)
  • + slow_mode_seconds (int64)
  • + tags_descriptions (varchar2)
  • + thumbnails (varchar2)
  • + topic_timer (varchar2)
  • + trust_level (int64)

Alle Treiberwechsel, 26.0 bis 27.0