Users_User_badgesByUsername: Discourse itgen_dce_users_user_badgesbyusername_plural
read only REST
- Catalog:
Discourse - Schema:
Users - Label: itgen_dce_users_user_badgesbyusername_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_User_badgesByUsername 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 |
|---|---|---|---|---|---|
badge_ |
int32 |
Badge ID | filters on the platform, writable, badge_ |
||
count |
int32 |
Count | filters on the platform, writable, count |
||
created_ |
datetime |
Created at | filters on the platform, writable, created_ |
||
granted_ |
datetime |
Granted At | filters on the platform, writable, granted_ |
||
granted_ |
int32 |
Granted by ID | filters on the platform, writable, granted_ |
||
id |
int32 |
ID | filters on the platform, writable, id |
||
post_ |
int32 |
Post ID | filters on the platform, writable, post_ |
||
post_ |
int32 |
Post Number | filters on the platform, writable, post_ |
||
topic_ |
int32 |
Topic ID | filters on the platform, writable, topic_ |
||
user_ |
char |
User Admin | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Avatar Template | filters on the platform, writable, ::ancestor. |
||
user_ |
decimal |
User Badge Count | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Edit | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Edit Email | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Edit Name | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Edit Username | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Send Private Message to User | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Can Send Private Messages | filters on the platform, writable, ::ancestor. |
||
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, ::ancestor. |
||
user_ |
varchar2 |
itgen_dce_user_custom_fields | writable | The JSON text of the nested object. | |
user_ |
decimal |
User ID | filters on the platform, writable, ::ancestor. |
||
user_ |
int32 |
itgen_dce_user_id2 | 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, ::ancestor. |
||
user_ |
varchar2 |
User Last Seen at | filters on the platform, writable, ::ancestor. |
||
user_ |
char |
User Moderator | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Name | writable | The JSON text of the nested object. | |
user_ |
decimal |
User Pending Count | filters on the platform, writable, ::ancestor. |
||
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, ::ancestor. |
||
user_ |
varchar2 |
User Title | writable | The JSON text of the nested object. | |
user_ |
decimal |
User Trust Level | filters on the platform, writable, ::ancestor. |
||
user_ |
varchar2 |
User Uploaded Avatar ID | writable | The JSON text of the nested object. | |
user_ |
varchar2 |
User Name | filters on the platform, writable, ::ancestor. |
||
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.Users_User_badgesByUsername is removed
A statement that reads Discourse.Users.Users_User_badgesByUsername fails after the upgrade. It had 39 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