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 |
`` | |||
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. |
||
archived |
char |
Archived | filters on the platform, writable, ::ancestor. |
||
auto_ |
varchar2 |
itgen_dce_auto_close_at | writable | The JSON text of the nested object. | |
auto_ |
char |
Auto Close Based On Last Post | writable, ::ancestor. |
||
auto_ |
varchar2 |
Auto Close Hours | writable | The JSON text of the nested object. | |
avatar_ |
varchar2 |
Avatar Template | writable, avatar_ |
||
bookmarked |
varchar2 |
Bookmarked | writable | The JSON text of the nested object. | |
can_ |
char |
Can Flag Topic | writable, ::ancestor. |
||
category_ |
decimal |
Category ID | filters on the platform, writable, ::ancestor. |
||
chunk_ |
decimal |
Chunk Size | filters on the platform, writable, ::ancestor. |
||
closed |
char |
Closed | filters on the platform, writable, ::ancestor. |
||
created_ |
varchar2 |
Created at | filters on the platform, writable, ::ancestor. |
||
created_ |
varchar2 |
Created by Avatar Template | writable, ::ancestor. |
||
created_ |
decimal |
Created by ID | writable, ::ancestor. |
||
created_ |
varchar2 |
Created by User Name | writable, ::ancestor. |
||
deleted_ |
varchar2 |
Deleted At | writable | The JSON text of the nested object. | |
deleted_ |
varchar2 |
Deleted By | writable | The JSON text of the nested object. | |
draft |
varchar2 |
Draft | writable | The JSON text of the nested object. | |
draft_ |
varchar2 |
Draft Key | filters on the platform, writable, ::ancestor. |
||
draft_ |
varchar2 |
Draft Sequence | writable | The JSON text of the nested object. | |
fancy_ |
varchar2 |
Fancy Title | filters on the platform, writable, ::ancestor. |
||
has_ |
char |
Has Summary | filters on the platform, writable, ::ancestor. |
||
highest_ |
decimal |
Highest Post Number | filters on the platform, writable, ::ancestor. |
||
id |
decimal |
ID | writable, id |
||
id_2 |
decimal |
ID 2 | filters on the platform, writable, ::ancestor. |
||
last_ |
varchar2 |
Last Posted at | writable | The JSON text of the nested object. | |
last_ |
varchar2 |
Last Poster Avatar Template | writable, ::ancestor. |
||
last_ |
decimal |
Last Poster ID | writable, ::ancestor. |
||
last_ |
varchar2 |
Last Poster Username | writable, ::ancestor. |
||
like_ |
decimal |
#Likes | filters on the platform, writable, ::ancestor. |
||
notification_ |
decimal |
Notification Level | writable, ::ancestor. |
||
participant_ |
decimal |
Participant Count | filters on the platform, writable, ::ancestor. |
||
pinned |
char |
Pinned | filters on the platform, writable, ::ancestor. |
||
pinned_ |
varchar2 |
Pinned at | filters on the platform, writable, ::ancestor. |
||
pinned_ |
char |
Pinned Globally | filters on the platform, writable, ::ancestor. |
||
pinned_ |
varchar2 |
Pinned Until | writable | The JSON text of the nested object. | |
post_ |
decimal |
#Posts | writable, post_ |
||
posts_ |
decimal |
#Posts | filters on the platform, writable, ::ancestor. |
||
reply_ |
decimal |
#Replies | filters on the platform, writable, ::ancestor. |
||
slug |
varchar2 |
Slug | filters on the platform, writable, ::ancestor. |
||
title |
varchar2 |
Title | filters on the platform, writable, ::ancestor. |
||
unpinned |
varchar2 |
Unpinned | writable | The JSON text of the nested object. | |
user_ |
decimal |
User ID | filters on the platform, writable, ::ancestor. |
||
username |
varchar2 |
User Name | writable, username |
||
views |
decimal |
Views | filters on the platform, writable, ::ancestor. |
||
visible |
char |
Visible | filters on the platform, writable, ::ancestor. |
||
word_ |
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:
Changes of This Table, 26.0 to 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 more changes
Parameter print is removed from Discourse.Topics.t_DetailsParticipantsById
A call that passes the parameter fails after the upgrade.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
- importance 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)