t_Timeline_lookup0ById: Discourse itgen_dce_t_timeline_lookup0byid_plural
read only REST
- Catalog:
Discourse - Schema:
Topics - Label: itgen_dce_t_timeline_lookup0byid_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_Timeline_lookup0ById 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. |
||
bookmarked |
varchar2 |
Bookmarked | writable | The JSON text of the nested object. | |
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. |
||
deleted_ |
varchar2 |
Deleted At | writable | The JSON text of the nested object. | |
deleted_ |
varchar2 |
Deleted By | writable | The JSON text of the nested object. | |
details_ |
varchar2 |
itgen_dce_details_auto_close_at | writable | The JSON text of the nested object. | |
details_ |
char |
Detail Auto Close Based On Last Post | filters on the platform, writable, ::ancestor. |
||
details_ |
varchar2 |
itgen_dce_details_auto_close_hours | writable | The JSON text of the nested object. | |
details_ |
char |
Detail Can Flag Topic | filters on the platform, writable, ::ancestor. |
||
details_ |
varchar2 |
Detail Created by Avatar Template | filters on the platform, writable, ::ancestor. |
||
details_ |
decimal |
Detail Created by ID | filters on the platform, writable, ::ancestor. |
||
details_ |
varchar2 |
Detail Created by User Name | filters on the platform, writable, ::ancestor. |
||
details_ |
varchar2 |
Detail Last Poster Avatar Template | filters on the platform, writable, ::ancestor. |
||
details_ |
decimal |
Detail Last Poster ID | filters on the platform, writable, ::ancestor. |
||
details_ |
varchar2 |
Detail Last Poster User Name | filters on the platform, writable, ::ancestor. |
||
details_ |
decimal |
Detail Notification Level | filters on the platform, writable, ::ancestor. |
||
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 | filters on the platform, writable, ::ancestor. |
||
last_ |
varchar2 |
Last Posted at | writable | The JSON text of the nested object. | |
like_ |
decimal |
#Likes | filters on the platform, 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. | |
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. |
||
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
Table function Discourse.Topics.t_Timeline_lookup0ById is removed
A statement that reads Discourse.Topics.t_Timeline_lookup0ById fails after the upgrade. It had 43 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