Users_UserGroupsByUsername: Discourse itgen_dce_users_usergroupsbyusername_plural
read only REST
- Catalog:
Discourse - Schema:
Users - Label: itgen_dce_users_usergroupsbyusername_plural
Get a single user by username
Can only retrieve data.
Summary
Get a single user by username
API Source
- Endpoint:
/users/{username}.json - Operation:
get /users/{username}.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 |
|---|---|---|---|---|
username |
`` |
Table Columns
The columns of the table Users_UserGroupsByUsername 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 | writable, ::ancestor. |
||
alias_ |
decimal |
Alias Level | writable, alias_ |
||
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 | writable, ::ancestor. |
||
badge_ |
decimal |
#Badges | writable, ::ancestor. |
||
can_ |
char |
Can Edit | writable, ::ancestor. |
||
can_ |
char |
Can Edit Email | writable, ::ancestor. |
||
can_ |
char |
Can Edit Name | writable, ::ancestor. |
||
can_ |
char |
Can Edit Username | writable, ::ancestor. |
||
can_ |
char |
Can Send Private Message to User | writable, ::ancestor. |
||
can_ |
char |
Can Send Private Messages | writable, ::ancestor. |
||
card_ |
varchar2 |
itgen_dce_card_badge | writable | The JSON text of the nested object. | |
created_ |
varchar2 |
Created at | writable, ::ancestor. |
||
custom_ |
varchar2 |
Custom Fields | writable | The JSON text of the nested object. | |
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. | |
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 | writable, ::ancestor. |
||
invited_ |
varchar2 |
Invited By | writable | The JSON text of the nested object. | |
is_ |
char |
Is Member | writable, is_ |
||
last_ |
varchar2 |
Last Posted at | writable, ::ancestor. |
||
last_ |
varchar2 |
Last Seen at | writable, ::ancestor. |
||
mentionable |
char |
Mentionable | writable, mentionable |
||
moderator |
char |
Moderator | writable, ::ancestor. |
||
name |
varchar2 |
Name | writable, name |
||
name_2 |
varchar2 |
Name 2 | writable | The JSON text of the nested object. | |
notification_ |
varchar2 |
Notification Level | writable | The JSON text of the nested object. | |
pending_ |
decimal |
Pending Count | writable, ::ancestor. |
||
primary_ |
char |
Primary Group | writable, primary_ |
||
primary_ |
varchar2 |
itgen_dce_primary_group_flair_bg_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_color | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
itgen_dce_primary_group_flair_url | writable | The JSON text of the nested object. | |
primary_ |
varchar2 |
Primary Group Name | writable | The JSON text of the nested object. | |
profile_ |
decimal |
Profile View Count | 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. | |
trust_ |
decimal |
Trust Level | writable, ::ancestor. |
||
uploaded_ |
varchar2 |
Uploaded Avatar ID | writable | The JSON text of the nested object. | |
user_ |
decimal |
#Users | writable, user_ |
||
username |
varchar2 |
User Name | writable, ::ancestor. |
||
visible |
char |
Visible | writable, visible |
||
website_ |
varchar2 |
itgen_dce_website_name | writable | The JSON text of the nested object. |
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.Users.Users_UserGroupsByUsername is removed
A statement that reads Discourse.Users.Users_UserGroupsByUsername fails after the upgrade. It had 47 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