invantive documentation
Invantive Support ForumsLog In / Sign Up

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_id int32 Badge ID filters on the platform, writable, badge_id
count int32 Count filters on the platform, writable, count
created_at datetime Created at filters on the platform, writable, created_at
granted_at datetime Granted At filters on the platform, writable, granted_at
granted_by_id int32 Granted by ID filters on the platform, writable, granted_by_id
id int32 ID filters on the platform, writable, id
post_id int32 Post ID filters on the platform, writable, post_id
post_number int32 Post Number filters on the platform, writable, post_number
topic_id int32 Topic ID filters on the platform, writable, topic_id
user_admin char User Admin filters on the platform, writable, ::ancestor.user.admin
user_avatar_template varchar2 User Avatar Template filters on the platform, writable, ::ancestor.user.avatar_template
user_badge_count decimal User Badge Count filters on the platform, writable, ::ancestor.user.badge_count
user_can_edit char User Can Edit filters on the platform, writable, ::ancestor.user.can_edit
user_can_edit_email char User Can Edit Email filters on the platform, writable, ::ancestor.user.can_edit_email
user_can_edit_name char User Can Edit Name filters on the platform, writable, ::ancestor.user.can_edit_name
user_can_edit_username char User Can Edit Username filters on the platform, writable, ::ancestor.user.can_edit_username
user_can_send_private_message_to_user char User Can Send Private Message to User filters on the platform, writable, ::ancestor.user.can_send_private_message_to_user
user_can_send_private_messages char User Can Send Private Messages filters on the platform, writable, ::ancestor.user.can_send_private_messages
user_card_badge varchar2 itgen_dce_user_card_badge writable The JSON text of the nested object.
user_created_at varchar2 User Created at filters on the platform, writable, ::ancestor.user.created_at
user_custom_fields varchar2 itgen_dce_user_custom_fields writable The JSON text of the nested object.
user_id decimal User ID filters on the platform, writable, ::ancestor.user.id
user_id2 int32 itgen_dce_user_id2 filters on the platform, writable, user_id
user_invited_by varchar2 User Invited By writable The JSON text of the nested object.
user_last_posted_at varchar2 User Last Posted at filters on the platform, writable, ::ancestor.user.last_posted_at
user_last_seen_at varchar2 User Last Seen at filters on the platform, writable, ::ancestor.user.last_seen_at
user_moderator char User Moderator filters on the platform, writable, ::ancestor.user.moderator
user_name varchar2 User Name writable The JSON text of the nested object.
user_pending_count decimal User Pending Count filters on the platform, writable, ::ancestor.user.pending_count
user_primary_group_flair_bg_color varchar2 itgen_dce_user_primary_group_flair_bg_color writable The JSON text of the nested object.
user_primary_group_flair_color varchar2 itgen_dce_user_primary_group_flair_color writable The JSON text of the nested object.
user_primary_group_flair_url varchar2 itgen_dce_user_primary_group_flair_url writable The JSON text of the nested object.
user_primary_group_name varchar2 User Primary Group Name writable The JSON text of the nested object.
user_profile_view_count decimal User Profile View Count filters on the platform, writable, ::ancestor.user.profile_view_count
user_title varchar2 User Title writable The JSON text of the nested object.
user_trust_level decimal User Trust Level filters on the platform, writable, ::ancestor.user.trust_level
user_uploaded_avatar_id varchar2 User Uploaded Avatar ID writable The JSON text of the nested object.
user_username varchar2 User Name filters on the platform, writable, ::ancestor.user.username
user_website_name 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

All changes of the driver, 26.0 to 27.0