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

# 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` | `` | [x] |  |  |
| `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.::ancestor.::ancestor.admin` |  |
| `archetype` | `varchar2` | Archetype | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.archetype` |  |
| `archived` | `char` | Archived | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.archived` |  |
| `avatar_template` | `varchar2` | Avatar Template | [ ] | writable, `::ancestor.::ancestor.::ancestor.avatar_template` |  |
| `avg_time` | `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_delete` | `char` | Can Delete | [ ] | writable, `::ancestor.::ancestor.::ancestor.can_delete` |  |
| `can_edit` | `char` | Can Edit | [ ] | writable, `::ancestor.::ancestor.::ancestor.can_edit` |  |
| `can_recover` | `char` | Can Recover | [ ] | writable, `::ancestor.::ancestor.::ancestor.can_recover` |  |
| `can_view_edit_history` | `char` | Can View Edit History | [ ] | writable, `::ancestor.::ancestor.::ancestor.can_view_edit_history` |  |
| `can_wiki` | `char` | Can Wikify | [ ] | writable, `::ancestor.::ancestor.::ancestor.can_wiki` |  |
| `category_id` | `decimal` | Category ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.category_id` |  |
| `chunk_size` | `decimal` | Chunk Size | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.chunk_size` |  |
| `closed` | `char` | Closed | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.closed` |  |
| `cooked` | `varchar2` | Cooked | [ ] | writable, `::ancestor.::ancestor.::ancestor.cooked` |  |
| `created_at` | `varchar2` | Created at | [ ] | writable, `::ancestor.::ancestor.::ancestor.created_at` |  |
| `created_at_2` | `varchar2` | Created at 2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.created_at` |  |
| `deleted_at` | `varchar2` | Deleted At | [ ] | writable | The JSON text of the nested object. |
| `deleted_at_2` | `varchar2` | Deleted at 2 | [ ] | writable | The JSON text of the nested object. |
| `deleted_by` | `varchar2` | Deleted By | [ ] | writable | The JSON text of the nested object. |
| `details_auto_close_at` | `varchar2` | itgen_dce_details_auto_close_at | [ ] | writable | The JSON text of the nested object. |
| `details_auto_close_based_on_last_post` | `char` | Detail Auto Close Based On Last Post | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.details.auto_close_based_on_last_post` |  |
| `details_auto_close_hours` | `varchar2` | itgen_dce_details_auto_close_hours | [ ] | writable | The JSON text of the nested object. |
| `details_can_flag_topic` | `char` | Detail Can Flag Topic | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.details.can_flag_topic` |  |
| `details_created_by_avatar_template` | `varchar2` | Detail Created by Avatar Template | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.details.created_by.avatar_template` |  |
| `details_created_by_id` | `decimal` | Detail Created by ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.details.created_by.id` |  |
| `details_created_by_username` | `varchar2` | Detail Created by User Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.details.created_by.username` |  |
| `details_last_poster_avatar_template` | `varchar2` | Detail Last Poster Avatar Template | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.details.last_poster.avatar_template` |  |
| `details_last_poster_id` | `decimal` | Detail Last Poster ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.details.last_poster.id` |  |
| `details_last_poster_username` | `varchar2` | Detail Last Poster User Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.details.last_poster.username` |  |
| `details_notification_level` | `decimal` | Detail Notification Level | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.details.notification_level` |  |
| `display_username` | `varchar2` | Display User Name | [ ] | writable, `::ancestor.::ancestor.::ancestor.display_username` |  |
| `draft` | `varchar2` | Draft | [ ] | writable | The JSON text of the nested object. |
| `draft_key` | `varchar2` | Draft Key | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.draft_key` |  |
| `draft_sequence` | `varchar2` | Draft Sequence | [ ] | writable | The JSON text of the nested object. |
| `edit_reason` | `varchar2` | Edit Reason | [ ] | writable | The JSON text of the nested object. |
| `fancy_title` | `varchar2` | Fancy Title | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.fancy_title` |  |
| `has_summary` | `char` | Has Summary | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.has_summary` |  |
| `hidden` | `char` | Hidden | [ ] | writable, `::ancestor.::ancestor.::ancestor.hidden` |  |
| `hidden_reason_id` | `varchar2` | itgen_dce_hidden_reason_id | [ ] | writable | The JSON text of the nested object. |
| `highest_post_number` | `decimal` | Highest Post Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.highest_post_number` |  |
| `html` | `varchar2` | HTML | [ ] | writable, `html` |  |
| `id` | `varchar2` | ID | [ ] | writable, `id` |  |
| `id_2` | `decimal` | ID 2 | [ ] | writable, `::ancestor.::ancestor.::ancestor.id` |  |
| `id_3` | `decimal` | ID 3 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.id` |  |
| `incoming_link_count` | `decimal` | #Incoming Links | [ ] | writable, `::ancestor.::ancestor.::ancestor.incoming_link_count` |  |
| `last_posted_at` | `varchar2` | Last Posted at | [ ] | writable | The JSON text of the nested object. |
| `like_count` | `decimal` | #Likes | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.like_count` |  |
| `moderator` | `char` | Moderator | [ ] | writable, `::ancestor.::ancestor.::ancestor.moderator` |  |
| `name` | `varchar2` | Name | [ ] | writable, `::ancestor.name` |  |
| `name_2` | `varchar2` | Name 2 | [ ] | writable, `::ancestor.::ancestor.::ancestor.name` |  |
| `participant_count` | `decimal` | Participant Count | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.participant_count` |  |
| `pinned` | `char` | Pinned | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.pinned` |  |
| `pinned_at` | `varchar2` | Pinned at | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.pinned_at` |  |
| `pinned_globally` | `char` | Pinned Globally | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.pinned_globally` |  |
| `pinned_until` | `varchar2` | Pinned Until | [ ] | writable | The JSON text of the nested object. |
| `polls_votes` | `varchar2` | itgen_dce_polls_votes | [ ] | writable, `::ancestor.::ancestor.::ancestor.polls_votes.poll` |  |
| `post_number` | `decimal` | Post Number | [ ] | writable, `::ancestor.::ancestor.::ancestor.post_number` |  |
| `post_type` | `decimal` | Post Type | [ ] | writable, `::ancestor.::ancestor.::ancestor.post_type` |  |
| `posts_count` | `decimal` | #Posts | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.posts_count` |  |
| `primary_group_flair_bg_color` | `varchar2` | itgen_dce_primary_group_flair_bg_color | [ ] | writable | The JSON text of the nested object. |
| `primary_group_flair_color` | `varchar2` | itgen_dce_primary_group_flair_color | [ ] | writable | The JSON text of the nested object. |
| `primary_group_flair_url` | `varchar2` | itgen_dce_primary_group_flair_url | [ ] | writable | The JSON text of the nested object. |
| `primary_group_name` | `varchar2` | Primary Group Name | [ ] | writable | The JSON text of the nested object. |
| `quote_count` | `decimal` | #Quotes | [ ] | writable, `::ancestor.::ancestor.::ancestor.quote_count` |  |
| `read` | `char` | Read | [ ] | writable, `::ancestor.::ancestor.::ancestor.read` |  |
| `reads` | `decimal` | #Reads | [ ] | writable, `::ancestor.::ancestor.::ancestor.reads` |  |
| `reply_count` | `decimal` | #Replies | [ ] | writable, `::ancestor.::ancestor.::ancestor.reply_count` |  |
| `reply_count_2` | `decimal` | Reply Count 2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.reply_count` |  |
| `reply_to_post_number` | `varchar2` | Reply to Post Number | [ ] | writable | The JSON text of the nested object. |
| `score` | `decimal` | Score | [ ] | writable, `::ancestor.::ancestor.::ancestor.score` |  |
| `slug` | `varchar2` | Slug | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.slug` |  |
| `staff` | `char` | Staff | [ ] | writable, `::ancestor.::ancestor.::ancestor.staff` |  |
| `status` | `varchar2` | Status | [ ] | writable, `::ancestor.status` |  |
| `title` | `varchar2` | Title | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.title` |  |
| `topic_id` | `decimal` | Topic ID | [ ] | writable, `::ancestor.::ancestor.::ancestor.topic_id` |  |
| `topic_slug` | `varchar2` | Topic Slug | [ ] | writable, `::ancestor.::ancestor.::ancestor.topic_slug` |  |
| `trust_level` | `decimal` | Trust Level | [ ] | writable, `::ancestor.::ancestor.::ancestor.trust_level` |  |
| `type` | `varchar2` | Type | [ ] | writable, `::ancestor.type` |  |
| `unpinned` | `varchar2` | Unpinned | [ ] | writable | The JSON text of the nested object. |
| `updated_at` | `varchar2` | Updated at | [ ] | writable, `::ancestor.::ancestor.::ancestor.updated_at` |  |
| `user_deleted` | `char` | User Deleted | [ ] | writable, `::ancestor.::ancestor.::ancestor.user_deleted` |  |
| `user_id` | `decimal` | User ID | [ ] | writable, `::ancestor.::ancestor.::ancestor.user_id` |  |
| `user_id_2` | `decimal` | User ID 2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.user_id` |  |
| `user_title` | `varchar2` | User Title | [ ] | writable | The JSON text of the nested object. |
| `username` | `varchar2` | User Name | [ ] | writable, `::ancestor.::ancestor.::ancestor.username` |  |
| `version` | `decimal` | Version | [ ] | writable, `::ancestor.::ancestor.::ancestor.version` |  |
| `views` | `decimal` | Views | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.views` |  |
| `visible` | `char` | Visible | [ ] | filters on the platform, writable, `::ancestor.::ancestor.::ancestor.::ancestor.::ancestor.visible` |  |
| `voters` | `int64` | Voters | [ ] | writable, `::ancestor.voters` |  |
| `votes` | `int64` | Votes | [ ] | writable, `votes` |  |
| `wiki` | `char` | Wiki | [ ] | writable, `::ancestor.::ancestor.::ancestor.wiki` |  |
| `word_count` | `varchar2` | Word Count | [ ] | writable | The JSON text of the nested object. |
| `yours` | `char` | Yours | [ ] | writable, `::ancestor.::ancestor.::ancestor.yours` |  |



## 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

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

##### 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.

<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 5

</div>

</div>

[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)

