invantive documentation
Invantive Support ForumsLog In / Sign Up

Top_Topic_listTopicsPosters: Discourse Top Topic Posters

read only REST

  • Catalog: Discourse
  • Schema: Topics
  • Label: Top Topic Posters

Get the top topics

Can only retrieve data.

Summary

Get the top topics

API Source

  • Endpoint: /top.json
  • Operation: get /top.json

Performance Characteristics

Characteristic Value
Average access latency (ms) 243
Write rows per minute 219

The result can be cached on the client.

Table Columns

The columns of the table Top_Topic_listTopicsPosters 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, ::ancestor.archetype
archived char Archived writable, ::ancestor.archived
bookmarked char Bookmarked writable, ::ancestor.bookmarked
bumped char Bumped writable, ::ancestor.bumped
bumped_at varchar2 Bumped at writable, ::ancestor.bumped_at
can_create_topic char Can Create Topic writable, ::ancestor.::ancestor.can_create_topic
category_id decimal Category ID writable, ::ancestor.category_id
closed char Closed writable, ::ancestor.closed
created_at varchar2 Created at writable, ::ancestor.created_at
description varchar2 Description writable, description
draft varchar2 Draft writable The JSON text of the nested object.
draft_key varchar2 Draft Key writable, ::ancestor.::ancestor.draft_key
draft_sequence decimal Draft Sequence writable, ::ancestor.::ancestor.draft_sequence
extras varchar2 Extras writable, extras
fancy_title varchar2 Fancy Title writable, ::ancestor.fancy_title
for_period varchar2 For Period writable, ::ancestor.::ancestor.for_period
has_summary char Has Summary writable, ::ancestor.has_summary
highest_post_number decimal Highest Post Number writable, ::ancestor.highest_post_number
id decimal ID writable, ::ancestor.id
image_url varchar2 Image URL writable The JSON text of the nested object.
last_posted_at varchar2 Last Posted at writable, ::ancestor.last_posted_at
last_poster_username varchar2 Last Poster Username writable, ::ancestor.last_poster_username
last_read_post_number decimal Last Read Post Number writable, ::ancestor.last_read_post_number
like_count decimal #Likes writable, ::ancestor.like_count
liked char Liked writable, ::ancestor.liked
new_posts decimal New Posts writable, ::ancestor.new_posts
notification_level decimal Notification Level writable, ::ancestor.notification_level
per_page decimal Per Page writable, ::ancestor.::ancestor.per_page
pinned char Pinned writable, ::ancestor.pinned
pinned_globally char Pinned Globally writable, ::ancestor.pinned_globally
posts_count decimal #Posts writable, ::ancestor.posts_count
reply_count decimal #Replies writable, ::ancestor.reply_count
slug varchar2 Slug writable, ::ancestor.slug
title varchar2 Title writable, ::ancestor.title
unpinned varchar2 Unpinned writable The JSON text of the nested object.
unread decimal Unread writable, ::ancestor.unread
unseen char Unseen writable, ::ancestor.unseen
user_id decimal User ID writable, user_id
views decimal Views writable, ::ancestor.views
visible char Visible writable, ::ancestor.visible

Keys

Key Column Refers to Kind Description
Top_Topic_listTopicsPosters_category_id_cnd category_id Categories.id Candidate Not stated by Discourse; found on the data of the smoke forum on 2026-10-31, where every filled value is in the referenced table.
Top_Topic_listTopicsPosters_id_cnd id Top_Topic_listTopics.id Candidate Not stated by Discourse; found on the data of the smoke forum on 2026-10-31, where every filled value is in the referenced table.
Top_Topic_listTopicsPosters_user_id_fk user_id Top_Users.id Key

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

  • ~ category_id (database_data_type: decimal → int64)
  • ~ category_id (dotnet_data_type: decimal → int64)
  • ~ draft_sequence (database_data_type: decimal → int64)
  • ~ draft_sequence (dotnet_data_type: decimal → int64)
  • ~ highest_post_number (database_data_type: decimal → int64)
  • ~ highest_post_number (dotnet_data_type: decimal → int64)
  • ~ id (database_data_type: decimal → int64)
  • ~ id (dotnet_data_type: decimal → int64)
  • ~ last_read_post_number (database_data_type: decimal → int64)
  • ~ last_read_post_number (dotnet_data_type: decimal → int64)
  • ~ like_count (database_data_type: decimal → int64)
  • ~ like_count (dotnet_data_type: decimal → int64)
  • - new_posts
  • ~ notification_level (database_data_type: decimal → int64)
  • ~ notification_level (dotnet_data_type: decimal → int64)

20 more changes

Discourse.Topics.Top_Topic_listTopicsPosters: type changes

Type of Discourse.Topics.Top_Topic_listTopicsPosters changes from table to tablefunction.

What to Do

Check statements, views and scripts that use it before the upgrade.

  • can break a statement
  • table → tablefunction
  • importance 3
Parameter per_page is added to Discourse.Topics.Top_Topic_listTopicsPosters

Optional.

  • importance 2
Parameter period is added to Discourse.Topics.Top_Topic_listTopicsPosters

Optional.

  • importance 2

  • ~ per_page (database_data_type: decimal → int64)
  • ~ per_page (dotnet_data_type: decimal → int64)
  • ~ posts_count (database_data_type: decimal → int64)
  • ~ posts_count (dotnet_data_type: decimal → int64)
  • ~ reply_count (database_data_type: decimal → int64)
  • ~ reply_count (dotnet_data_type: decimal → int64)
  • ~ unpinned (database_data_type: varchar2 → char)
  • ~ unpinned (dotnet_data_type: string → boolean)
  • - unread
  • ~ user_id (database_data_type: decimal → int64)
  • ~ user_id (dotnet_data_type: decimal → int64)
  • ~ views (database_data_type: decimal → int64)
  • ~ views (dotnet_data_type: decimal → int64)
  • + featured_link (varchar2)
  • + op_like_count (int64)
  • + primary_group_id (int64)
  • + unread_posts (int64)

All changes of the driver, 26.0 to 27.0