invantive documentation
Invantive Support ForumsLog In / Sign Up

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_2 varchar2 Archetype 2 filters on the platform, writable, ::ancestor.::ancestor.archetype
archived char Archived writable, archived
archived_2 char Archived 2 filters on the platform, writable, ::ancestor.::ancestor.archived
auto_close_at varchar2 itgen_dce_auto_close_at writable The JSON text of the nested object.
auto_close_based_on_last_post char Auto Close Based On Last Post writable, ::ancestor.auto_close_based_on_last_post
auto_close_hours varchar2 Auto Close Hours writable The JSON text of the nested object.
bookmarked varchar2 Bookmarked writable The JSON text of the nested object.
bookmarked_2 varchar2 Bookmarked 2 writable The JSON text of the nested object.
bumped char Bumped writable, bumped
bumped_at varchar2 Bumped at writable, bumped_at
can_flag_topic char Can Flag Topic writable, ::ancestor.can_flag_topic
category_id decimal Category ID writable, category_id
category_id_2 decimal Category ID 2 filters on the platform, writable, ::ancestor.::ancestor.category_id
chunk_size decimal Chunk Size filters on the platform, writable, ::ancestor.::ancestor.chunk_size
closed char Closed writable, closed
closed_2 char Closed 2 filters on the platform, writable, ::ancestor.::ancestor.closed
created_at varchar2 Created at writable, created_at
created_at_2 varchar2 Created at 2 filters on the platform, writable, ::ancestor.::ancestor.created_at
created_by_avatar_template varchar2 Created by Avatar Template writable, ::ancestor.created_by.avatar_template
created_by_id decimal Created by ID writable, ::ancestor.created_by.id
created_by_username varchar2 Created by User Name writable, ::ancestor.created_by.username
deleted_at varchar2 Deleted At writable The JSON text of the nested object.
deleted_by varchar2 Deleted By writable The JSON text of the nested object.
draft varchar2 Draft writable The JSON text of the nested object.
draft_key varchar2 Draft Key filters on the platform, writable, ::ancestor.::ancestor.draft_key
draft_sequence varchar2 Draft Sequence writable The JSON text of the nested object.
excerpt varchar2 Excerpt writable, excerpt
fancy_title varchar2 Fancy Title writable, fancy_title
fancy_title_2 varchar2 Fancy Title 2 filters on the platform, writable, ::ancestor.::ancestor.fancy_title
has_summary char Has Summary filters on the platform, writable, ::ancestor.::ancestor.has_summary
highest_post_number decimal Highest Post Number writable, highest_post_number
highest_post_number_2 decimal Highest Post Number 2 filters on the platform, writable, ::ancestor.::ancestor.highest_post_number
id decimal ID writable, id
id_2 decimal ID 2 filters on the platform, writable, ::ancestor.::ancestor.id
image_url varchar2 Image URL writable, image_url
last_posted_at varchar2 Last Posted at writable, last_posted_at
last_posted_at_2 varchar2 Last Posted at 2 writable The JSON text of the nested object.
last_poster_avatar_template varchar2 Last Poster Avatar Template writable, ::ancestor.last_poster.avatar_template
last_poster_id decimal Last Poster ID writable, ::ancestor.last_poster.id
last_poster_username varchar2 Last Poster Username writable, ::ancestor.last_poster.username
like_count decimal #Likes writable, like_count
like_count_2 decimal Like Count 2 filters on the platform, writable, ::ancestor.::ancestor.like_count
liked varchar2 Liked writable The JSON text of the nested object.
notification_level decimal Notification Level writable, ::ancestor.notification_level
participant_count decimal Participant Count filters on the platform, writable, ::ancestor.::ancestor.participant_count
pinned char Pinned writable, pinned
pinned_2 char Pinned 2 filters on the platform, writable, ::ancestor.::ancestor.pinned
pinned_at varchar2 Pinned at filters on the platform, writable, ::ancestor.::ancestor.pinned_at
pinned_globally char Pinned Globally filters on the platform, writable, ::ancestor.::ancestor.pinned_globally
pinned_until varchar2 Pinned Until writable The JSON text of the nested object.
posts_count decimal #Posts writable, posts_count
posts_count_2 decimal Posts Count 2 filters on the platform, writable, ::ancestor.::ancestor.posts_count
reply_count decimal #Replies writable, reply_count
reply_count_2 decimal Reply Count 2 filters on the platform, writable, ::ancestor.::ancestor.reply_count
slug varchar2 Slug writable, slug
slug_2 varchar2 Slug 2 filters on the platform, writable, ::ancestor.::ancestor.slug
title varchar2 Title writable, title
title_2 varchar2 Title 2 filters on the platform, writable, ::ancestor.::ancestor.title
unpinned varchar2 Unpinned writable The JSON text of the nested object.
unpinned_2 varchar2 Unpinned 2 writable The JSON text of the nested object.
unseen char Unseen writable, unseen
user_id decimal User ID filters on the platform, writable, ::ancestor.::ancestor.user_id
views decimal Views writable, views
views_2 decimal Views 2 filters on the platform, writable, ::ancestor.::ancestor.views
visible char Visible writable, visible
visible_2 char Visible 2 filters on the platform, writable, ::ancestor.::ancestor.visible
word_count 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

All changes of the driver, 26.0 to 27.0