invantive documentation
Invantive Support ForumsLog In / Sign Up

Latest_Topic_listTopics: Discourse Latest Topics

read only REST

  • Catalog: Discourse
  • Schema: Topics
  • Label: Latest Topics

Get the latest topics

Can only retrieve data.

Summary

Get the latest topics

API Source

  • Endpoint: /latest.json
  • Operation: get /latest.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
ascending `` defaults to desc, add ascending=true to sort asc
order `` Values: default, created, activity, views, posts, category, likes, op_likes, posters.

Table Columns

The columns of the table Latest_Topic_listTopics 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
archived char Archived writable, archived
bookmarked varchar2 Bookmarked writable The JSON text of the nested object.
bumped char Bumped writable, bumped
bumped_at varchar2 Bumped at writable, bumped_at
can_create_topic char Can Create Topic writable, ::ancestor.can_create_topic
can_have_answer char Can Have Answer filters on the platform, writable, can_have_answer
can_vote char Can Vote filters on the platform, writable, can_vote
category_id int64 Category ID writable, category_id
closed char Closed writable, closed
created_at varchar2 Created at writable, created_at
draft varchar2 Draft writable The JSON text of the nested object.
draft_key varchar2 Draft Key writable, ::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
has_accepted_answer char Has Accepted Answer filters on the platform, writable, has_accepted_answer
has_summary char Has Summary writable, has_summary
highest_post_number int64 Highest Post Number writable, highest_post_number
id int64 ID writable, id
image_url varchar2 Image URL writable The JSON text of the nested object.
last_posted_at varchar2 Last Posted at writable, last_posted_at
last_poster_username varchar2 Last Poster Username writable, last_poster_username
last_read_post_number int32 Last Read Post Number filters on the platform, writable, last_read_post_number
like_count int64 #Likes writable, like_count
liked varchar2 Liked writable The JSON text of the nested object.
new_posts int32 New Posts filters on the platform, writable, new_posts
notification_level int32 Notification Level filters on the platform, writable, notification_level
per_page int64 Per Page writable, ::ancestor.per_page
pinned char Pinned writable, pinned
pinned_globally char Pinned Globally writable, pinned_globally
posts_count int64 #Posts writable, posts_count
reply_count int64 #Replies writable, reply_count
slug varchar2 Slug writable, slug
title varchar2 Title writable, title
unpinned varchar2 Unpinned writable The JSON text of the nested object.
unread int32 Unread filters on the platform, writable, unread
unseen char Unseen writable, unseen
user_voted char User Voted filters on the platform, writable, user_voted
views int64 Views writable, views
visible char Visible writable, visible
vote_count int32 Vote Count filters on the platform, writable, vote_count

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

Parameter ascending of Discourse.Topics.Latest_Topic_listTopics: dotnet data type changes

Dotnet data type changes from boolean to string.

What to Do

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

  • can break a statement
  • boolean → string
  • importance 3

  • ~ bookmarked (database_data_type: varchar2 → char)
  • ~ bookmarked (dotnet_data_type: string → boolean)
  • ~ draft_sequence (database_data_type: varchar2 → int64)
  • ~ draft_sequence (dotnet_data_type: string → int64)
  • - excerpt
  • ~ last_read_post_number (database_data_type: int32 → int64)
  • ~ last_read_post_number (dotnet_data_type: int32 → int64)
  • ~ liked (database_data_type: varchar2 → char)
  • ~ liked (dotnet_data_type: string → boolean)
  • ~ notification_level (database_data_type: int32 → int64)
  • ~ notification_level (dotnet_data_type: int32 → int64)
  • + featured_link (varchar2)
  • + op_like_count (int64)
  • + unread_posts (int64)

1 more changes

Parameter per_page is added to Discourse.Topics.Latest_Topic_listTopics

Optional.

  • importance 2

All changes of the driver, 26.0 to 27.0