t_Post_streamPostsPollsPollOptionsById: Discourse itgen_dce_t_post_streampostspollspolloptionsbyid_plural
read only REST
- Catalog:
Discourse - Schema:
Topics - Label: itgen_dce_t_post_streampostspollspolloptionsbyid_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_Post_streamPostsPollsPollOptionsById 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 |
|---|---|---|---|---|---|
admin |
char |
Administrator | writable, ::ancestor. |
||
archetype |
varchar2 |
Archetype | filters on the platform, writable, ::ancestor. |
||
archived |
char |
Archived | filters on the platform, writable, ::ancestor. |
||
avatar_ |
varchar2 |
Avatar Template | writable, ::ancestor. |
||
avg_ |
varchar2 |
itgen_dce_avg_time | writable | The JSON text of the nested object. | |
bookmarked |
varchar2 |
Bookmarked | writable | The JSON text of the nested object. | |
can_ |
char |
Can Delete | writable, ::ancestor. |
||
can_ |
char |
Can Edit | writable, ::ancestor. |
||
can_ |
char |
Can Recover | writable, ::ancestor. |
||
can_ |
char |
Can View Edit History | writable, ::ancestor. |
||
can_ |
char |
Can Wikify | 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. |
||
cooked |
varchar2 |
Cooked | writable, ::ancestor. |
||
created_ |
varchar2 |
Created at | writable, ::ancestor. |
||
created_ |
varchar2 |
Created at 2 | filters on the platform, writable, ::ancestor. |
||
deleted_ |
varchar2 |
Deleted At | writable | The JSON text of the nested object. | |
deleted_ |
varchar2 |
Deleted at 2 | 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. |
||
display_ |
varchar2 |
Display User Name | 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. | |
edit_ |
varchar2 |
Edit Reason | 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. |
||
hidden |
char |
Hidden | writable, ::ancestor. |
||
hidden_ |
varchar2 |
itgen_dce_hidden_reason_id | writable | The JSON text of the nested object. | |
highest_ |
decimal |
Highest Post Number | filters on the platform, writable, ::ancestor. |
||
html |
varchar2 |
HTML | writable, html |
||
id |
varchar2 |
ID | writable, id |
||
id_2 |
decimal |
ID 2 | writable, ::ancestor. |
||
id_3 |
decimal |
ID 3 | filters on the platform, writable, ::ancestor. |
||
incoming_ |
decimal |
#Incoming Links | writable, ::ancestor. |
||
last_ |
varchar2 |
Last Posted at | writable | The JSON text of the nested object. | |
like_ |
decimal |
#Likes | filters on the platform, writable, ::ancestor. |
||
moderator |
char |
Moderator | writable, ::ancestor. |
||
name |
varchar2 |
Name | writable, ::ancestor. |
||
name_2 |
varchar2 |
Name 2 | 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. | |
polls_ |
varchar2 |
itgen_dce_polls_votes | writable, ::ancestor. |
||
post_ |
decimal |
Post Number | writable, ::ancestor. |
||
post_ |
decimal |
Post Type | writable, ::ancestor. |
||
posts_ |
decimal |
#Posts | filters on the platform, writable, ::ancestor. |
||
primary_ |
varchar2 |
itgen_dce_primary_group_flair_bg_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_url | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
Primary Group Name | writable | The JSON text of the nested object. | |
quote_ |
decimal |
#Quotes | writable, ::ancestor. |
||
read |
char |
Read | writable, ::ancestor. |
||
reads |
decimal |
#Reads | writable, ::ancestor. |
||
reply_ |
decimal |
#Replies | writable, ::ancestor. |
||
reply_ |
decimal |
Reply Count 2 | filters on the platform, writable, ::ancestor. |
||
reply_ |
varchar2 |
Reply to Post Number | writable | The JSON text of the nested object. | |
score |
decimal |
Score | writable, ::ancestor. |
||
slug |
varchar2 |
Slug | filters on the platform, writable, ::ancestor. |
||
staff |
char |
Staff | writable, ::ancestor. |
||
status |
varchar2 |
Status | writable, ::ancestor. |
||
title |
varchar2 |
Title | filters on the platform, writable, ::ancestor. |
||
topic_ |
decimal |
Topic ID | writable, ::ancestor. |
||
topic_ |
varchar2 |
Topic Slug | writable, ::ancestor. |
||
trust_ |
decimal |
Trust Level | writable, ::ancestor. |
||
type |
varchar2 |
Type | writable, ::ancestor. |
||
unpinned |
varchar2 |
Unpinned | writable | The JSON text of the nested object. | |
updated_ |
varchar2 |
Updated at | writable, ::ancestor. |
||
user_ |
char |
User Deleted | writable, ::ancestor. |
||
user_ |
decimal |
User ID | writable, ::ancestor. |
||
user_ |
decimal |
User ID 2 | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Title | writable | The JSON text of the nested object. | |
username |
varchar2 |
User Name | writable, ::ancestor. |
||
version |
decimal |
Version | writable, ::ancestor. |
||
views |
decimal |
Views | filters on the platform, writable, ::ancestor. |
||
visible |
char |
Visible | filters on the platform, writable, ::ancestor. |
||
voters |
int64 |
Voters | writable, ::ancestor. |
||
votes |
int64 |
Votes | writable, votes |
||
wiki |
char |
Wiki | writable, ::ancestor. |
||
word_ |
varchar2 |
Word Count | writable | The JSON text of the nested object. | |
yours |
char |
Yours | writable, ::ancestor. |
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_Post_streamPostsPollsPollOptionsById is removed
A statement that reads Discourse.Topics.t_Post_streamPostsPollsPollOptionsById fails after the upgrade. It had 94 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