AdminUsers_GroupsById: Discourse Admin Users Groups by ID
read only REST
- Catalog:
Discourse - Schema:
Admin - Label: Admin Users Groups 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 AdminUsers_GroupsById 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, ::ancestor. |
||
admin |
char |
Administrator | filters on the platform, writable, ::ancestor. |
||
allow_ |
char |
Allow Membership Requests | writable, allow_ |
||
approved_ |
varchar2 |
itgen_dce_approved_by | writable | The JSON text of the nested object. | |
automatic |
char |
Automatic | writable, automatic |
||
automatic_ |
varchar2 |
Automatic Membership Email Domains | writable | The JSON text of the nested object. | |
automatic_ |
char |
Automatic Membership Retroactive | writable, automatic_ |
||
avatar_ |
varchar2 |
Avatar Template | filters on the platform, writable, ::ancestor. |
||
badge_ |
decimal |
#Badges | filters on the platform, writable, ::ancestor. |
||
bio_ |
varchar2 |
Bio Cooked | writable | The JSON text of the nested object. | |
bio_ |
varchar2 |
Bio Raw | writable | The JSON text of the nested object. | |
bounce_ |
decimal |
Bounce Score | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Activate | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Be Anonymized | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Be Deleted | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Deactivate | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Delete All Posts | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Disable Second Factor | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Grant Admin | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Grant Moderation | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Impersonate | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Revoke Admin | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Revoke Moderation | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can Send Activation Email | filters on the platform, writable, ::ancestor. |
||
can_ |
char |
Can View Action Logs | filters on the platform, writable, ::ancestor. |
||
created_ |
varchar2 |
Created at | filters on the platform, writable, ::ancestor. |
||
created_ |
decimal |
Created at Age | filters on the platform, writable, ::ancestor. |
||
days_ |
decimal |
Days Visited | filters on the platform, writable, ::ancestor. |
||
default_ |
decimal |
Default Notification Level | writable, default_ |
||
display_ |
varchar2 |
Display Name | writable, display_ |
||
flag_ |
decimal |
Flag Level | filters on the platform, writable, ::ancestor. |
||
flags_ |
decimal |
Flags Given Count | filters on the platform, writable, ::ancestor. |
||
flags_ |
decimal |
Flags Received Count | filters on the platform, writable, ::ancestor. |
||
flair_ |
varchar2 |
Flair Background Color | writable | The JSON text of the nested object. | |
flair_ |
varchar2 |
Flair Color | writable | The JSON text of the nested object. | |
flair_ |
varchar2 |
Flair URL | writable | The JSON text of the nested object. | |
full_ |
varchar2 |
Full Name | writable | The JSON text of the nested object. | |
full_ |
varchar2 |
Full Suspend Reason | filters on the platform, writable, ::ancestor. |
||
grant_ |
varchar2 |
Grant Trust Level | writable | The JSON text of the nested object. | |
has_ |
char |
Has Messages | writable, has_ |
||
id |
decimal |
ID | writable, id |
||
id_2 |
decimal |
ID 2 | filters on the platform, writable, ::ancestor. |
||
incoming_ |
varchar2 |
Incoming Email | writable | The JSON text of the nested object. | |
ip_ |
varchar2 |
IP Address | filters on the platform, writable, ::ancestor. |
||
last_ |
decimal |
Last Emailed Age | filters on the platform, writable, ::ancestor. |
||
last_ |
varchar2 |
Last Emailed at | filters on the platform, writable, ::ancestor. |
||
last_ |
decimal |
Last Seen Age | filters on the platform, writable, ::ancestor. |
||
last_ |
varchar2 |
Last Seen at | filters on the platform, writable, ::ancestor. |
||
like_ |
decimal |
#Likes | filters on the platform, writable, ::ancestor. |
||
like_ |
decimal |
Like Given Count | filters on the platform, writable, ::ancestor. |
||
manual_ |
varchar2 |
Manual Locked Trust Level | writable | The JSON text of the nested object. | |
membership_ |
varchar2 |
Membership Request Template | writable | The JSON text of the nested object. | |
mentionable_ |
decimal |
Mentionable Level | writable, mentionable_ |
||
messageable_ |
decimal |
Messageable Level | writable, messageable_ |
||
moderator |
char |
Moderator | filters on the platform, writable, ::ancestor. |
||
name |
varchar2 |
Name | writable, name |
||
name_2 |
varchar2 |
Name 2 | filters on the platform, writable, ::ancestor. |
||
post_ |
decimal |
#Posts | filters on the platform, writable, ::ancestor. |
||
posts_ |
decimal |
Posts Read Count | filters on the platform, writable, ::ancestor. |
||
primary_ |
char |
Primary Group | writable, primary_ |
||
primary_ |
varchar2 |
Primary Group ID | writable | The JSON text of the nested object. | |
private_ |
decimal |
Private Topics Count | filters on the platform, writable, ::ancestor. |
||
public_ |
char |
Public Admission | writable, public_ |
||
public_ |
char |
Public Exit | writable, public_ |
||
registration_ |
varchar2 |
Registration IP Address | filters on the platform, writable, ::ancestor. |
||
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, ::ancestor. |
||
suspended |
char |
Suspended | filters on the platform, writable, ::ancestor. |
||
suspended_ |
varchar2 |
Suspended at | filters on the platform, writable, ::ancestor. |
||
suspended_ |
varchar2 |
Suspended by Avatar Template | filters on the platform, writable, ::ancestor. |
||
suspended_ |
decimal |
Suspended by ID | filters on the platform, writable, ::ancestor. |
||
suspended_ |
varchar2 |
Suspended by Username | filters on the platform, writable, ::ancestor. |
||
suspended_ |
varchar2 |
Suspended till | filters on the platform, writable, ::ancestor. |
||
time_ |
decimal |
Time Read | filters on the platform, writable, ::ancestor. |
||
title |
varchar2 |
Title | writable | The JSON text of the nested object. | |
title_ |
varchar2 |
Title 2 | writable | The JSON text of the nested object. | |
topic_ |
decimal |
#Topics | filters on the platform, writable, ::ancestor. |
||
topics_ |
decimal |
Topics Entered | filters on the platform, writable, ::ancestor. |
||
trust_ |
decimal |
Trust Level | filters on the platform, writable, ::ancestor. |
||
user_ |
decimal |
#Users | writable, user_ |
||
user_ |
varchar2 |
User Fields 1 | writable | The JSON text of the nested object. | |
username |
varchar2 |
User Name | filters on the platform, writable, ::ancestor. |
||
username_ |
varchar2 |
Username Lowercase | filters on the platform, writable, ::ancestor. |
||
visibility_ |
decimal |
Visibility Level | writable, visibility_ |
||
warnings_ |
decimal |
Warnings Received Count | filters on the platform, 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
Table function Discourse.Admin.AdminUsers_GroupsById is removed
A statement that reads Discourse.Admin.AdminUsers_GroupsById fails after the upgrade. It had 88 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