AdminUsersById: Discourse Admin Users by ID
read only REST
- Catalog:
Discourse - Schema:
Admin - Label: Admin Users by ID
Get a specific user by id. Returns more info than the public user route.
Can only retrieve data.
Summary
Get a specific user by id. Returns more info than the public user route.
API Source
- Endpoint:
/admin/users/{id}.json - Operation:
get /admin/users/{id}.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 |
|---|---|---|---|---|
id |
`` |
Table Columns
The columns of the table AdminUsersById 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 |
||
approved_ |
varchar2 |
itgen_dce_approved_by | writable | The JSON text of the nested object. | |
avatar_ |
varchar2 |
Avatar Template | filters on the platform, writable, avatar_ |
||
badge_ |
decimal |
#Badges | filters on the platform, writable, badge_ |
||
bounce_ |
decimal |
Bounce Score | filters on the platform, writable, bounce_ |
||
can_ |
char |
Can Activate | filters on the platform, writable, can_ |
||
can_ |
char |
Can Be Anonymized | filters on the platform, writable, can_ |
||
can_ |
char |
Can Be Deleted | filters on the platform, writable, can_ |
||
can_ |
char |
Can Deactivate | filters on the platform, writable, can_ |
||
can_ |
char |
Can Delete All Posts | filters on the platform, writable, can_ |
||
can_ |
char |
Can Disable Second Factor | filters on the platform, writable, can_ |
||
can_ |
char |
Can Grant Admin | filters on the platform, writable, can_ |
||
can_ |
char |
Can Grant Moderation | filters on the platform, writable, can_ |
||
can_ |
char |
Can Impersonate | filters on the platform, writable, can_ |
||
can_ |
char |
Can Revoke Admin | filters on the platform, writable, can_ |
||
can_ |
char |
Can Revoke Moderation | filters on the platform, writable, can_ |
||
can_ |
char |
Can Send Activation Email | filters on the platform, writable, can_ |
||
can_ |
char |
Can View Action Logs | filters on the platform, writable, can_ |
||
created_ |
varchar2 |
Created at | filters on the platform, writable, created_ |
||
created_ |
decimal |
Created at Age | filters on the platform, writable, created_ |
||
days_ |
decimal |
Days Visited | filters on the platform, writable, days_ |
||
flag_ |
decimal |
Flag Level | filters on the platform, writable, flag_ |
||
flags_ |
decimal |
Flags Given Count | filters on the platform, writable, flags_ |
||
flags_ |
decimal |
Flags Received Count | filters on the platform, writable, flags_ |
||
full_ |
varchar2 |
Full Suspend Reason | filters on the platform, writable, full_ |
||
id |
decimal |
ID | filters on the platform, writable, id |
||
ip_ |
varchar2 |
IP Address | filters on the platform, writable, ip_ |
||
last_ |
decimal |
Last Emailed Age | filters on the platform, writable, last_ |
||
last_ |
varchar2 |
Last Emailed at | filters on the platform, writable, last_ |
||
last_ |
decimal |
Last Seen Age | filters on the platform, writable, last_ |
||
last_ |
varchar2 |
Last Seen at | filters on the platform, writable, last_ |
||
like_ |
decimal |
#Likes | filters on the platform, writable, like_ |
||
like_ |
decimal |
Like Given Count | filters on the platform, writable, like_ |
||
manual_ |
varchar2 |
Manual Locked Trust Level | writable | The JSON text of the nested object. | |
moderator |
char |
Moderator | filters on the platform, writable, moderator |
||
name |
varchar2 |
Name | filters on the platform, writable, name |
||
post_ |
decimal |
#Posts | filters on the platform, writable, post_ |
||
posts_ |
decimal |
Posts Read Count | filters on the platform, writable, posts_ |
||
primary_ |
varchar2 |
Primary Group ID | writable | The JSON text of the nested object. | |
private_ |
decimal |
Private Topics Count | filters on the platform, writable, private_ |
||
registration_ |
varchar2 |
Registration IP Address | filters on the platform, writable, registration_ |
||
reset_ |
varchar2 |
Reset Bounce Score After | writable | The JSON text of the nested object. | |
silence_ |
varchar2 |
Silence Reason | writable | The JSON text of the nested object. | |
silenced_ |
varchar2 |
Silenced By | writable | The JSON text of the nested object. | |
single_ |
varchar2 |
Single Sign on Record | writable | The JSON text of the nested object. | |
staged |
char |
Staged | filters on the platform, writable, staged |
||
suspended |
char |
Suspended | filters on the platform, writable, suspended |
||
suspended_ |
varchar2 |
Suspended at | filters on the platform, writable, suspended_ |
||
suspended_ |
varchar2 |
Suspended by Avatar Template | filters on the platform, writable, suspended_ |
||
suspended_ |
decimal |
Suspended by ID | filters on the platform, writable, suspended_ |
||
suspended_ |
varchar2 |
Suspended by Username | filters on the platform, writable, suspended_ |
||
suspended_ |
varchar2 |
Suspended till | filters on the platform, writable, suspended_ |
||
time_ |
decimal |
Time Read | filters on the platform, writable, time_ |
||
title |
varchar2 |
Title | writable | The JSON text of the nested object. | |
topic_ |
decimal |
#Topics | filters on the platform, writable, topic_ |
||
topics_ |
decimal |
Topics Entered | filters on the platform, writable, topics_ |
||
trust_ |
decimal |
Trust Level | filters on the platform, writable, trust_ |
||
user_ |
varchar2 |
User Fields 1 | writable | The JSON text of the nested object. | |
username |
varchar2 |
User Name | filters on the platform, writable, username |
||
username_ |
varchar2 |
Username Lowercase | filters on the platform, writable, username_ |
||
warnings_ |
decimal |
Warnings Received Count | filters on the platform, writable, warnings_ |
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
Table function Discourse.Admin.AdminUsersById is removed
A statement that reads Discourse.Admin.AdminUsersById fails after the upgrade. It had 62 columns. The operation is not in the updated Discourse specification, or has another name.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
- importance 5