AdminUsersListByFlag: Discourse Admin Users List by Flag
read only REST
- Catalog:
Discourse - Schema:
Users - Label: Admin Users List by Flag
Returns a list of users
Can only retrieve data.
Summary
Returns a list of users
API Source
- Endpoint:
/admin/users/list/{flag}.json - Operation:
get /admin/users/list/{flag}.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 |
`` | |||
flag |
`` | Values: active, new, staff, suspended, blocked, suspect. | ||
order |
`` | Values: created, last_emailed, seen, username, email, trust_level, days_visited, posts_read, topics_viewed, posts, read_time. | ||
show_ |
`` |
Table Columns
The columns of the table AdminUsersListByFlag 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 |
|---|---|---|---|---|---|
active |
char |
Active | filters on the platform, writable, active |
||
admin |
char |
Administrator | filters on the platform, writable, admin |
||
avatar_ |
varchar2 |
Avatar Template | filters on the platform, writable, avatar_ |
||
blocked |
char |
Blocked | filters on the platform, writable, blocked |
||
created_ |
varchar2 |
Created at | filters on the platform, writable, created_ |
||
created_ |
varchar2 |
Created at Age | filters on the platform, writable, created_ |
||
days_ |
int64 |
Days Visited | filters on the platform, writable, days_ |
||
email |
varchar2 |
filters on the platform, writable, email |
|||
flag_ |
int64 |
Flag Level | filters on the platform, writable, flag_ |
||
id |
int64 |
ID | filters on the platform, writable, id |
||
last_ |
varchar2 |
Last Emailed Age | filters on the platform, writable, last_ |
||
last_ |
varchar2 |
Last Emailed at | filters on the platform, writable, last_ |
||
last_ |
varchar2 |
Last Seen Age | filters on the platform, writable, last_ |
||
last_ |
varchar2 |
Last Seen at | filters on the platform, writable, last_ |
||
moderator |
char |
Moderator | filters on the platform, writable, moderator |
||
post_ |
int64 |
#Posts | filters on the platform, writable, post_ |
||
posts_ |
int64 |
Posts Read Count | filters on the platform, writable, posts_ |
||
staged |
char |
Staged | filters on the platform, writable, staged |
||
suspended |
varchar2 |
Suspended | writable | The JSON text of the nested object. | |
suspended_ |
varchar2 |
Suspended at | writable | The JSON text of the nested object. | |
suspended_ |
varchar2 |
Suspended till | writable | The JSON text of the nested object. | |
time_ |
varchar2 |
Time Read | filters on the platform, writable, time_ |
||
title |
varchar2 |
Title | filters on the platform, writable, title |
||
topics_ |
int64 |
Topics Entered | filters on the platform, writable, topics_ |
||
trust_ |
int64 |
Trust Level | filters on the platform, writable, trust_ |
||
trust_ |
char |
Trust Level Locked | filters on the platform, writable, trust_ |
||
username |
varchar2 |
User Name | filters on the platform, writable, username |
||
username_ |
varchar2 |
Username Lowercase | filters on the platform, 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
-blocked~created_at_age(database_data_type:varchar2→decimal)~created_at_age(dotnet_data_type:string→decimal)-flag_level~last_emailed_age(database_data_type:varchar2→decimal)~last_emailed_age(dotnet_data_type:string→decimal)~last_seen_age(database_data_type:varchar2→decimal)~last_seen_age(dotnet_data_type:string→decimal)-suspended-suspended_at-suspended_till~time_read(database_data_type:varchar2→int64)~time_read(dotnet_data_type:string→int64)-trust_level_locked-username_lower
7 more changes
Parameter ascending is removed from Discourse.Users.AdminUsersListByFlag
A call that passes the parameter fails after the upgrade.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
- importance 4
Parameter asc is added to Discourse.Users.AdminUsersListByFlag
Optional.
- importance 2
Parameter email is added to Discourse.Users.AdminUsersListByFlag
Optional.
- importance 2
Parameter ip is added to Discourse.Users.AdminUsersListByFlag
Optional.
- importance 2
Parameter stats is added to Discourse.Users.AdminUsersListByFlag
Optional.
- importance 2
+manual_locked_trust_level(varchar2)+name(varchar2)