---
title: "t_DetailsParticipantsById (Discourse)"
description: "Topic Details Participants by ID"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Topics.t_DetailsParticipantsById
original: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Topics.t_DetailsParticipantsById
updated: 2026-11-01T16:08:49Z
license: https://documentation.invantive.eu/en/
---

# t_DetailsParticipantsById: Discourse Topic Details Participants by ID

`read only` `REST`

- Catalog: `Discourse`
- Schema: `Topics`
- Label: Topic Details Participants by ID

Get a single topic

Can only retrieve data.

## Summary

Get a single topic

## API Source

- Endpoint: `/t/{id}.json`
- Operation: `get /t/{id}.json`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 243 |
| Write rows per minute | 219 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `id` | `` | [x] |  |  |
| `print` | `` | [ ] |  | Will return up to 1000 posts in a topic |

## Table Columns

The columns of the table `t_DetailsParticipantsById` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | 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` | Auto Close Based On Last Post | [ ] | writable, `::ancestor.auto_close_based_on_last_post` |  |
| `auto_close_hours` | `varchar2` | Auto Close Hours | [ ] | writable | The JSON text of the nested object. |
| `avatar_template` | `varchar2` | Avatar Template | [ ] | writable, `avatar_template` |  |
| `bookmarked` | `varchar2` | Bookmarked | [ ] | writable | The JSON text of the nested object. |
| `can_flag_topic` | `char` | Can Flag Topic | [ ] | writable, `::ancestor.can_flag_topic` |  |
| `category_id` | `decimal` | Category ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.category_id` |  |
| `chunk_size` | `decimal` | Chunk Size | [ ] | filters on the platform, writable, `::ancestor.::ancestor.chunk_size` |  |
| `closed` | `char` | Closed | [ ] | filters on the platform, writable, `::ancestor.::ancestor.closed` |  |
| `created_at` | `varchar2` | Created at | [ ] | filters on the platform, writable, `::ancestor.::ancestor.created_at` |  |
| `created_by_avatar_template` | `varchar2` | Created by Avatar Template | [ ] | writable, `::ancestor.created_by.avatar_template` |  |
| `created_by_id` | `decimal` | Created by ID | [ ] | writable, `::ancestor.created_by.id` |  |
| `created_by_username` | `varchar2` | Created by User Name | [ ] | writable, `::ancestor.created_by.username` |  |
| `deleted_at` | `varchar2` | Deleted At | [ ] | writable | The JSON text of the nested object. |
| `deleted_by` | `varchar2` | Deleted By | [ ] | writable | The JSON text of the nested object. |
| `draft` | `varchar2` | Draft | [ ] | writable | The JSON text of the nested object. |
| `draft_key` | `varchar2` | Draft Key | [ ] | filters on the platform, writable, `::ancestor.::ancestor.draft_key` |  |
| `draft_sequence` | `varchar2` | Draft Sequence | [ ] | writable | The JSON text of the nested object. |
| `fancy_title` | `varchar2` | Fancy Title | [ ] | filters on the platform, writable, `::ancestor.::ancestor.fancy_title` |  |
| `has_summary` | `char` | Has Summary | [ ] | filters on the platform, writable, `::ancestor.::ancestor.has_summary` |  |
| `highest_post_number` | `decimal` | Highest Post Number | [ ] | 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` | Last Posted at | [ ] | writable | The JSON text of the nested object. |
| `last_poster_avatar_template` | `varchar2` | Last Poster Avatar Template | [ ] | writable, `::ancestor.last_poster.avatar_template` |  |
| `last_poster_id` | `decimal` | Last Poster ID | [ ] | writable, `::ancestor.last_poster.id` |  |
| `last_poster_username` | `varchar2` | Last Poster Username | [ ] | writable, `::ancestor.last_poster.username` |  |
| `like_count` | `decimal` | #Likes | [ ] | filters on the platform, writable, `::ancestor.::ancestor.like_count` |  |
| `notification_level` | `decimal` | Notification Level | [ ] | writable, `::ancestor.notification_level` |  |
| `participant_count` | `decimal` | Participant Count | [ ] | filters on the platform, writable, `::ancestor.::ancestor.participant_count` |  |
| `pinned` | `char` | Pinned | [ ] | filters on the platform, writable, `::ancestor.::ancestor.pinned` |  |
| `pinned_at` | `varchar2` | Pinned at | [ ] | filters on the platform, writable, `::ancestor.::ancestor.pinned_at` |  |
| `pinned_globally` | `char` | Pinned Globally | [ ] | filters on the platform, writable, `::ancestor.::ancestor.pinned_globally` |  |
| `pinned_until` | `varchar2` | Pinned Until | [ ] | 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` | User ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.user_id` |  |
| `username` | `varchar2` | User Name | [ ] | 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` | Word Count | [ ] | writable | The JSON text of the nested object. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

### Changes of This Table, 26.0 to 27.0

<a id="DCE-27.0-D682"></a><a id="DCE-27.0-D683"></a><a id="DCE-27.0-D684"></a><a id="DCE-27.0-D685"></a><a id="DCE-27.0-D686"></a><a id="DCE-27.0-D687"></a><a id="DCE-27.0-D688"></a><a id="DCE-27.0-D689"></a><a id="DCE-27.0-D690"></a><a id="DCE-27.0-D691"></a><a id="DCE-27.0-D692"></a><a id="DCE-27.0-D693"></a><a id="DCE-27.0-D694"></a><a id="DCE-27.0-D695"></a><a id="DCE-27.0-D696"></a>

- `-` `auto_close_at`
- `-` `auto_close_based_on_last_post`
- `-` `auto_close_hours`
- `~` `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`)
- `~` `created_by_id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `created_by_id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `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`)

<details>
<summary>

67 more changes

</summary>

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

##### Parameter print is removed from Discourse.Topics.t_DetailsParticipantsById

A call that passes the parameter fails after the upgrade.

<div class="rn-action">

**What to Do**

Check statements, views and scripts that use it before the upgrade.

</div>

<div class="rn-chips">

- **can break a statement**
- importance 4

</div>

</div>

<a id="DCE-27.0-D697"></a><a id="DCE-27.0-D698"></a><a id="DCE-27.0-D699"></a><a id="DCE-27.0-D700"></a><a id="DCE-27.0-D701"></a><a id="DCE-27.0-D702"></a><a id="DCE-27.0-D703"></a><a id="DCE-27.0-D704"></a><a id="DCE-27.0-D705"></a><a id="DCE-27.0-D706"></a><a id="DCE-27.0-D707"></a><a id="DCE-27.0-D708"></a><a id="DCE-27.0-D709"></a><a id="DCE-27.0-D710"></a><a id="DCE-27.0-D711"></a><a id="DCE-27.0-D712"></a><a id="DCE-27.0-D713"></a><a id="DCE-27.0-D714"></a><a id="DCE-27.0-D715"></a><a id="DCE-27.0-D716"></a><a id="DCE-27.0-D717"></a><a id="DCE-27.0-D718"></a><a id="DCE-27.0-D719"></a><a id="DCE-27.0-D720"></a><a id="DCE-27.0-D1709"></a><a id="DCE-27.0-D1710"></a><a id="DCE-27.0-D1711"></a><a id="DCE-27.0-D1712"></a><a id="DCE-27.0-D1713"></a><a id="DCE-27.0-D1714"></a><a id="DCE-27.0-D1715"></a><a id="DCE-27.0-D1716"></a><a id="DCE-27.0-D1717"></a><a id="DCE-27.0-D1718"></a><a id="DCE-27.0-D1719"></a><a id="DCE-27.0-D1720"></a><a id="DCE-27.0-D1721"></a><a id="DCE-27.0-D1722"></a><a id="DCE-27.0-D1723"></a><a id="DCE-27.0-D1724"></a><a id="DCE-27.0-D1725"></a><a id="DCE-27.0-D1726"></a><a id="DCE-27.0-D1727"></a><a id="DCE-27.0-D1728"></a><a id="DCE-27.0-D1729"></a><a id="DCE-27.0-D1730"></a><a id="DCE-27.0-D1731"></a><a id="DCE-27.0-D1732"></a><a id="DCE-27.0-D1733"></a><a id="DCE-27.0-D1734"></a><a id="DCE-27.0-D1735"></a><a id="DCE-27.0-D1736"></a><a id="DCE-27.0-D1737"></a><a id="DCE-27.0-D1738"></a><a id="DCE-27.0-D1739"></a><a id="DCE-27.0-D1740"></a><a id="DCE-27.0-D1741"></a><a id="DCE-27.0-D1742"></a><a id="DCE-27.0-D1743"></a><a id="DCE-27.0-D1744"></a><a id="DCE-27.0-D1745"></a><a id="DCE-27.0-D1746"></a><a id="DCE-27.0-D1747"></a><a id="DCE-27.0-D1748"></a><a id="DCE-27.0-D1749"></a><a id="DCE-27.0-D1750"></a>

- `~` `id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `id_2` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `id_2` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `last_poster_id` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `last_poster_id` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `like_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `like_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `notification_level` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `notification_level` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `participant_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `participant_count` (`dotnet_data_type`: `decimal` &rarr; `int64`)
- `~` `post_count` (`database_data_type`: `decimal` &rarr; `int64`)
- `~` `post_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`)
- `+` `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`)

</details>

[All changes of the driver, 26.0 to 27.0](/en/release-notes/drivers?driver=discourse&step=26.0-to-27.0#discourse-26.0-to-27.0)

