UsersByUsername: Discourse itgen_dce_usersbyusername_plural
read only REST
- Catalog:
Discourse - Schema:
Users - Label: itgen_dce_usersbyusername_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 UsersByUsername 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 |
|---|---|---|---|---|---|
user_ |
char |
User Admin | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User Avatar Template | filters on the platform, writable, user. |
||
user_ |
decimal |
User Badge Count | filters on the platform, writable, user. |
||
user_ |
char |
User Can Be Deleted | filters on the platform, writable, user. |
||
user_ |
char |
User Can Change Bio | filters on the platform, writable, user. |
||
user_ |
char |
User Can Change Location | filters on the platform, writable, user. |
||
user_ |
char |
User Can Change Website | filters on the platform, writable, user. |
||
user_ |
char |
User Can Delete All Posts | filters on the platform, writable, user. |
||
user_ |
char |
User Can Edit | filters on the platform, writable, user. |
||
user_ |
char |
User Can Edit Email | filters on the platform, writable, user. |
||
user_ |
char |
User Can Edit Name | filters on the platform, writable, user. |
||
user_ |
char |
User Can Edit Username | filters on the platform, writable, user. |
||
user_ |
char |
User Can Ignore User | filters on the platform, writable, user. |
||
user_ |
char |
User Can Mute User | filters on the platform, writable, user. |
||
user_ |
char |
User Can Send Private Message to User | filters on the platform, writable, user. |
||
user_ |
char |
User Can Send Private Messages | filters on the platform, writable, user. |
||
user_ |
char |
User Can Upload Profile Header | filters on the platform, writable, user. |
||
user_ |
char |
User Can Upload User Card Background | filters on the platform, writable, user. |
||
user_ |
varchar2 |
itgen_dce_user_card_badge | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
User Created at | filters on the platform, writable, user. |
||
user_ |
varchar2 |
itgen_dce_user_custom_fields | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
itgen_dce_user_email | filters on the platform, writable, user. |
||
user_ |
varchar2 |
itgen_dce_user_gravatar_avatar_template | filters on the platform, writable, user. |
||
user_ |
int32 |
itgen_dce_user_gravatar_avatar_upload_id | filters on the platform, writable, user. |
||
user_ |
char |
User Has Title Badges | filters on the platform, writable, user. |
||
user_ |
decimal |
User ID | filters on the platform, writable, user. |
||
user_ |
char |
User Ignored | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User Invited By | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
User Last Posted at | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User Last Seen at | filters on the platform, writable, user. |
||
user_ |
int32 |
User Mailing List Posts per Day | filters on the platform, writable, user. |
||
user_ |
char |
User Moderator | filters on the platform, writable, user. |
||
user_ |
char |
User Muted | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User Name | writable | The JSON text of the nested object. | |
user_ |
decimal |
User Pending Count | filters on the platform, writable, user. |
||
user_ |
int32 |
User Post Count | filters on the platform, writable, user. |
||
user_ |
varchar2 |
itgen_dce_user_primary_group_flair_bg_color | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
itgen_dce_user_primary_group_flair_color | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
itgen_dce_user_primary_group_flair_url | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
User Primary Group Name | writable | The JSON text of the nested object. | |
user_ |
decimal |
User Profile View Count | filters on the platform, writable, user. |
||
user_ |
int32 |
User Recent Time Read | filters on the platform, writable, user. |
||
user_ |
char |
User Second Factor Backup Enabled | filters on the platform, writable, user. |
||
user_ |
char |
User Second Factor Enabled | filters on the platform, writable, user. |
||
user_ |
char |
User Staged | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User System Avatar Template | filters on the platform, writable, user. |
||
user_ |
int32 |
User Time Read | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User Title | writable | The JSON text of the nested object. | |
user_ |
decimal |
User Trust Level | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User Uploaded Avatar ID | writable | The JSON text of the nested object. | |
user_ |
char |
User Use Logo Small as Avatar | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 0 End Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 0 Start Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 1 End Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 1 Start Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 2 End Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 2 Start Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 3 End Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 3 Start Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 4 End Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 4 Start Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 5 End Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 5 Start Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 6 End Time | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Notification Schedule Day 6 Start Time | filters on the platform, writable, user. |
||
user_ |
char |
User User Notification Schedule Enabled | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Allow Private Messages | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option Auto Track Topics After Milliseconds | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Automatically Unpin Topics | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option Digest After Minutes | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Dynamic Favicon | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Email Digests | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Email in Reply To | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option Email Level | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option Email Messages Level | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option Email Previous Replies | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Enable Allowed PM Users | filters on the platform, writable, user. |
||
user_ |
char |
itgen_dce_user_user_option_enable_defer | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Enable Quoting | filters on the platform, writable, user. |
||
user_ |
char |
User User Option External Links in New Tab | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Hide Profile and Presence | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Include TL0 in Digests | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option Like Notification Frequency | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Mailing List Mode | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option Mailing List Mode Frequency | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option New Topic Duration Minutes | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option Notification Level When Replying | filters on the platform, writable, user. |
||
user_ |
char |
User User Option Skip New User Tips | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User User Option Text Size | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option Text Size Seq | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option Theme Key Seq | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User User Option Title Count Mode | filters on the platform, writable, user. |
||
user_ |
int32 |
User User Option User ID | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User Name | filters on the platform, writable, user. |
||
user_ |
varchar2 |
itgen_dce_user_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.UsersByUsername is removed
A statement that reads Discourse.Users.UsersByUsername fails after the upgrade. It had 95 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