Latest_Topic_listTopicsPosters: Discourse Latest Topic Posters
read only REST
- Catalog:
Discourse - Schema:
Topics - Label: Latest Topic Posters
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_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. |
||
archived |
char |
Archived | writable, ::ancestor. |
||
bookmarked |
varchar2 |
Bookmarked | writable | The JSON text of the nested object. | |
bumped |
char |
Bumped | writable, ::ancestor. |
||
bumped_ |
varchar2 |
Bumped at | writable, ::ancestor. |
||
can_ |
char |
Can Create Topic | writable, ::ancestor. |
||
category_ |
int64 |
Category ID | writable, ::ancestor. |
||
closed |
char |
Closed | writable, ::ancestor. |
||
created_ |
varchar2 |
Created at | writable, ::ancestor. |
||
description |
varchar2 |
Description | writable, description |
||
draft |
varchar2 |
Draft | writable | The JSON text of the nested object. | |
draft_ |
varchar2 |
Draft Key | writable, ::ancestor. |
||
draft_ |
varchar2 |
Draft Sequence | writable | The JSON text of the nested object. | |
excerpt |
varchar2 |
Excerpt | writable, ::ancestor. |
||
extras |
varchar2 |
Extras | writable, extras |
||
fancy_ |
varchar2 |
Fancy Title | writable, ::ancestor. |
||
has_ |
char |
Has Summary | writable, ::ancestor. |
||
highest_ |
int64 |
Highest Post Number | writable, ::ancestor. |
||
id |
int64 |
ID | writable, ::ancestor. |
||
image_ |
varchar2 |
Image URL | writable | The JSON text of the nested object. | |
last_ |
varchar2 |
Last Posted at | writable, ::ancestor. |
||
last_ |
varchar2 |
Last Poster Username | writable, ::ancestor. |
||
like_ |
int64 |
#Likes | writable, ::ancestor. |
||
liked |
varchar2 |
Liked | writable | The JSON text of the nested object. | |
per_ |
int64 |
Per Page | writable, ::ancestor. |
||
pinned |
char |
Pinned | writable, ::ancestor. |
||
pinned_ |
char |
Pinned Globally | writable, ::ancestor. |
||
posts_ |
int64 |
#Posts | writable, ::ancestor. |
||
reply_ |
int64 |
#Replies | writable, ::ancestor. |
||
slug |
varchar2 |
Slug | writable, ::ancestor. |
||
title |
varchar2 |
Title | writable, ::ancestor. |
||
unpinned |
varchar2 |
Unpinned | writable | The JSON text of the nested object. | |
unseen |
char |
Unseen | writable, ::ancestor. |
||
user_ |
int64 |
User ID | writable, user_ |
||
views |
int64 |
Views | writable, ::ancestor. |
||
visible |
char |
Visible | 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
Parameter ascending of Discourse.Topics.Latest_Topic_listTopicsPosters: 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
Parameter per_page is added to Discourse.Topics.Latest_Topic_listTopicsPosters
Optional.
- importance 2
~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~liked(database_data_type:varchar2→char)~liked(dotnet_data_type:string→boolean)+featured_link(varchar2)+last_read_post_number(int64)+notification_level(int64)+op_like_count(int64)+primary_group_id(int64)+unread_posts(int64)