Top_Users: Discourse Top Users
read only REST
- Catalog:
Discourse - Schema:
Topics - Label: Top Users
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_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_ |
varchar2 |
Avatar Template | writable, avatar_ |
||
id |
decimal |
ID | writable, id |
||
moderator |
char |
Moderator | filters on the platform, writable, moderator |
||
topic_ |
char |
Topic List Can Create Topic | filters on the platform, writable, ::ancestor. |
||
topic_ |
varchar2 |
Topic List Draft | writable | The JSON text of the nested object. | |
topic_ |
varchar2 |
Topic List Draft Key | filters on the platform, writable, ::ancestor. |
||
topic_ |
decimal |
Topic List Draft Sequence | filters on the platform, writable, ::ancestor. |
||
topic_ |
varchar2 |
Topic List for Period | filters on the platform, writable, ::ancestor. |
||
topic_ |
decimal |
Topic List Per Page | filters on the platform, writable, ::ancestor. |
||
trust_ |
int32 |
Trust Level | filters on the platform, writable, trust_ |
||
username |
varchar2 |
User Name | writable, username |
Referenced By
- Top_Topic_listTopics
last_poster_username(Candidate) - Top_Topic_listTopicsPosters
user_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
Discourse.Topics.Top_Users: type changes
Type of Discourse.Topics.Top_Users 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_Users
Optional.
- importance 2
Parameter period is added to Discourse.Topics.Top_Users
Optional.
- importance 2
~id(database_data_type:decimal→int64)~id(dotnet_data_type:decimal→int64)~topic_list_draft_sequence(database_data_type:decimal→int64)~topic_list_draft_sequence(dotnet_data_type:decimal→int64)~topic_list_per_page(database_data_type:decimal→int64)~topic_list_per_page(dotnet_data_type:decimal→int64)+name(varchar2)