---
title: "t_Post_streamStreamById (Discourse)"
description: "Topic Post Stream Stream by ID"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/discourse/Discourse.Topics.t_Post_streamStreamById
original: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Topics.t_Post_streamStreamById
updated: 2026-11-16T20:47:43Z
license: https://documentation.invantive.eu/de/
---

# t_Post_streamStreamById: Discourse Topic Post Stream Stream by ID

`read only` `REST`

- Katalog: `Discourse`
- Schema: `Topics`
- Label: Topic Post Stream Stream 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` | `` | [x] |  |  |
| `print` | `` | [ ] |  | Will return up to 1000 posts in a topic |

## Tabellenspalten

Die Spalten der Tabelle `t_Post_streamStreamById` 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` |  |
| `bookmarked` | `varchar2` | Bookmarked | [ ] | writable | The JSON text of the nested object. |
| `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` |  |
| `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. |
| `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` |  |
| `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 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.id` |  |
| `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` |  |
| `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. |
| `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` |  |
| `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:

- [Discourse](/de/release-notes/drivers?driver=discourse)

### Änderungen an dieser Tabelle, 26.0 bis 27.0

<a id="DCE-27.0-D853"></a><a id="DCE-27.0-D854"></a><a id="DCE-27.0-D855"></a><a id="DCE-27.0-D856"></a><a id="DCE-27.0-D857"></a><a id="DCE-27.0-D858"></a><a id="DCE-27.0-D859"></a><a id="DCE-27.0-D860"></a><a id="DCE-27.0-D861"></a><a id="DCE-27.0-D862"></a><a id="DCE-27.0-D863"></a><a id="DCE-27.0-D864"></a><a id="DCE-27.0-D865"></a><a id="DCE-27.0-D866"></a><a id="DCE-27.0-D867"></a>

- `~` `bookmarked` (`database_data_type`: `varchar2` &rarr; `char`)
- `~` `bookmarked` (`dotnet_data_type`: `string` &rarr; `boolean`)
- `~` `category_id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `category_id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `chunk_size` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `chunk_size` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `-` `details_auto_close_at`
- `-` `details_auto_close_based_on_last_post`
- `-` `details_auto_close_hours`
- `~` `details_created_by_id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `details_created_by_id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `details_last_poster_id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `details_last_poster_id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `details_notification_level` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `details_notification_level` (`dotnet_data_type`: `decimal` &rarr; `int64`)

<details>
<summary>

53 weitere Änderungen

</summary>

<div class="rn-item" id="DCE-27.0-D1060">

##### Der Parameter „print“ wurde aus „Discourse.Topics.t_Post_streamStreamById“ entfernt.

Ein Aufruf, der diesen Parameter übergibt, schlägt nach dem Upgrade fehl.

<div class="rn-action">

**Was ist zu tun?**

Überprüfen Sie vor dem Upgrade alle Statements, Views und Skripte, die diese Spalte verwenden.

</div>

<div class="rn-chips">

- **kann ein Statement unterbrechen**
- Bedeutung 4

</div>

</div>

<a id="DCE-27.0-D868"></a><a id="DCE-27.0-D869"></a><a id="DCE-27.0-D870"></a><a id="DCE-27.0-D871"></a><a id="DCE-27.0-D872"></a><a id="DCE-27.0-D873"></a><a id="DCE-27.0-D874"></a><a id="DCE-27.0-D875"></a><a id="DCE-27.0-D876"></a><a id="DCE-27.0-D877"></a><a id="DCE-27.0-D878"></a><a id="DCE-27.0-D879"></a><a id="DCE-27.0-D880"></a><a id="DCE-27.0-D881"></a><a id="DCE-27.0-D882"></a><a id="DCE-27.0-D883"></a><a id="DCE-27.0-D884"></a><a id="DCE-27.0-D885"></a><a id="DCE-27.0-D886"></a><a id="DCE-27.0-D887"></a><a id="DCE-27.0-D1837"></a><a id="DCE-27.0-D1838"></a><a id="DCE-27.0-D1839"></a><a id="DCE-27.0-D1840"></a><a id="DCE-27.0-D1841"></a><a id="DCE-27.0-D1842"></a><a id="DCE-27.0-D1843"></a><a id="DCE-27.0-D1844"></a><a id="DCE-27.0-D1845"></a><a id="DCE-27.0-D1846"></a><a id="DCE-27.0-D1847"></a><a id="DCE-27.0-D1848"></a><a id="DCE-27.0-D1849"></a><a id="DCE-27.0-D1850"></a><a id="DCE-27.0-D1851"></a><a id="DCE-27.0-D1852"></a><a id="DCE-27.0-D1853"></a><a id="DCE-27.0-D1854"></a><a id="DCE-27.0-D1855"></a><a id="DCE-27.0-D1856"></a><a id="DCE-27.0-D1857"></a><a id="DCE-27.0-D1858"></a><a id="DCE-27.0-D1859"></a><a id="DCE-27.0-D1860"></a><a id="DCE-27.0-D1861"></a><a id="DCE-27.0-D1862"></a><a id="DCE-27.0-D1863"></a><a id="DCE-27.0-D1864"></a><a id="DCE-27.0-D1865"></a><a id="DCE-27.0-D1866"></a><a id="DCE-27.0-D1867"></a><a id="DCE-27.0-D1868"></a>

- `~` `draft_sequence` (`database_data_type`: `varchar2` &rarr; `int64`)
- `~` `draft_sequence` (`dotnet_data_type`: `string` &rarr; `int64`)
- `~` `highest_post_number` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `highest_post_number` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `like_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `like_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `participant_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `participant_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `posts_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `posts_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `reply_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `reply_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `user_id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `user_id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `views` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `views` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `word_count` (`database_data_type`: `varchar2` &rarr; `int64`)
- `~` `word_count` (`dotnet_data_type`: `string` &rarr; `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`)

</details>

[Alle Treiberwechsel, 26.0 bis 27.0](/de/release-notes/drivers?driver=discourse&step=26.0-to-27.0#discourse-26.0-to-27.0)
