t_DetailsSuggested_topicsById: Discourse itgen_dce_t_detailssuggested_topicsbyid_plural
read only REST
- Catalog:
Discourse - Schema:
Topics - Label: itgen_dce_t_detailssuggested_topicsbyid_plural
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_DetailsSuggested_topicsById 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 | writable, archetype |
||
archetype_ |
varchar2 |
Archetype 2 | filters on the platform, writable, ::ancestor. |
||
archived |
char |
Archived | writable, archived |
||
archived_ |
char |
Archived 2 | 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. | |
bookmarked |
varchar2 |
Bookmarked | writable | The JSON text of the nested object. | |
bookmarked_ |
varchar2 |
Bookmarked 2 | writable | The JSON text of the nested object. | |
bumped |
char |
Bumped | writable, bumped |
||
bumped_ |
varchar2 |
Bumped at | writable, bumped_ |
||
can_ |
char |
Can Flag Topic | writable, ::ancestor. |
||
category_ |
decimal |
Category ID | writable, category_ |
||
category_ |
decimal |
Category ID 2 | filters on the platform, writable, ::ancestor. |
||
chunk_ |
decimal |
Chunk Size | filters on the platform, writable, ::ancestor. |
||
closed |
char |
Closed | writable, closed |
||
closed_ |
char |
Closed 2 | filters on the platform, writable, ::ancestor. |
||
created_ |
varchar2 |
Created at | writable, created_ |
||
created_ |
varchar2 |
Created at 2 | 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. | |
excerpt |
varchar2 |
Excerpt | writable, excerpt |
||
fancy_ |
varchar2 |
Fancy Title | writable, fancy_ |
||
fancy_ |
varchar2 |
Fancy Title 2 | filters on the platform, writable, ::ancestor. |
||
has_ |
char |
Has Summary | filters on the platform, writable, ::ancestor. |
||
highest_ |
decimal |
Highest Post Number | writable, highest_ |
||
highest_ |
decimal |
Highest Post Number 2 | filters on the platform, writable, ::ancestor. |
||
id |
decimal |
ID | writable, id |
||
id_2 |
decimal |
ID 2 | filters on the platform, writable, ::ancestor. |
||
image_ |
varchar2 |
Image URL | writable, image_ |
||
last_ |
varchar2 |
Last Posted at | writable, last_ |
||
last_ |
varchar2 |
Last Posted at 2 | 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 | writable, like_ |
||
like_ |
decimal |
Like Count 2 | filters on the platform, writable, ::ancestor. |
||
liked |
varchar2 |
Liked | writable | The JSON text of the nested object. | |
notification_ |
decimal |
Notification Level | writable, ::ancestor. |
||
participant_ |
decimal |
Participant Count | filters on the platform, writable, ::ancestor. |
||
pinned |
char |
Pinned | writable, pinned |
||
pinned_ |
char |
Pinned 2 | 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. | |
posts_ |
decimal |
#Posts | writable, posts_ |
||
posts_ |
decimal |
Posts Count 2 | filters on the platform, writable, ::ancestor. |
||
reply_ |
decimal |
#Replies | writable, reply_ |
||
reply_ |
decimal |
Reply Count 2 | filters on the platform, writable, ::ancestor. |
||
slug |
varchar2 |
Slug | writable, slug |
||
slug_2 |
varchar2 |
Slug 2 | filters on the platform, writable, ::ancestor. |
||
title |
varchar2 |
Title | writable, title |
||
title_ |
varchar2 |
Title 2 | filters on the platform, writable, ::ancestor. |
||
unpinned |
varchar2 |
Unpinned | writable | The JSON text of the nested object. | |
unpinned_ |
varchar2 |
Unpinned 2 | writable | The JSON text of the nested object. | |
unseen |
char |
Unseen | writable, unseen |
||
user_ |
decimal |
User ID | filters on the platform, writable, ::ancestor. |
||
views |
decimal |
Views | writable, views |
||
views_ |
decimal |
Views 2 | filters on the platform, writable, ::ancestor. |
||
visible |
char |
Visible | writable, visible |
||
visible_ |
char |
Visible 2 | 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
Table function Discourse.Topics.t_DetailsSuggested_topicsById is removed
A statement that reads Discourse.Topics.t_DetailsSuggested_topicsById fails after the upgrade. It had 68 columns. The operation is not in the updated Discourse specification, or has another name.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
- importance 5