invantive documentation
Invantive Support ForumsLog In / Sign Up

Latest_Users: Discourse Latest Users

read only REST

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

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_Users 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 filters on the platform, writable, admin
avatar_template varchar2 Avatar Template writable, avatar_template
id int64 ID writable, id
moderator char Moderator filters on the platform, writable, moderator
topic_list_can_create_topic char Topic List Can Create Topic filters on the platform, writable, ::ancestor.topic_list.can_create_topic
topic_list_draft varchar2 Topic List Draft writable The JSON text of the nested object.
topic_list_draft_key varchar2 Topic List Draft Key filters on the platform, writable, ::ancestor.topic_list.draft_key
topic_list_draft_sequence varchar2 Topic List Draft Sequence writable The JSON text of the nested object.
topic_list_per_page int64 Topic List Per Page filters on the platform, writable, ::ancestor.topic_list.per_page
trust_level int32 Trust Level filters on the platform, writable, trust_level
username varchar2 User Name writable, username

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_Users: 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_Users

Optional.

  • importance 2

  • ~ topic_list_draft_sequence (database_data_type: varchar2 → int64)
  • ~ topic_list_draft_sequence (dotnet_data_type: string → int64)
  • + name (varchar2)

All changes of the driver, 26.0 to 27.0