invantive documentation
Invantive Support ForumsLog In / Sign Up

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_admin char User Admin filters on the platform, writable, user.admin
user_avatar_template varchar2 User Avatar Template filters on the platform, writable, user.avatar_template
user_badge_count decimal User Badge Count filters on the platform, writable, user.badge_count
user_can_be_deleted char User Can Be Deleted filters on the platform, writable, user.can_be_deleted
user_can_change_bio char User Can Change Bio filters on the platform, writable, user.can_change_bio
user_can_change_location char User Can Change Location filters on the platform, writable, user.can_change_location
user_can_change_website char User Can Change Website filters on the platform, writable, user.can_change_website
user_can_delete_all_posts char User Can Delete All Posts filters on the platform, writable, user.can_delete_all_posts
user_can_edit char User Can Edit filters on the platform, writable, user.can_edit
user_can_edit_email char User Can Edit Email filters on the platform, writable, user.can_edit_email
user_can_edit_name char User Can Edit Name filters on the platform, writable, user.can_edit_name
user_can_edit_username char User Can Edit Username filters on the platform, writable, user.can_edit_username
user_can_ignore_user char User Can Ignore User filters on the platform, writable, user.can_ignore_user
user_can_mute_user char User Can Mute User filters on the platform, writable, user.can_mute_user
user_can_send_private_message_to_user char User Can Send Private Message to User filters on the platform, writable, user.can_send_private_message_to_user
user_can_send_private_messages char User Can Send Private Messages filters on the platform, writable, user.can_send_private_messages
user_can_upload_profile_header char User Can Upload Profile Header filters on the platform, writable, user.can_upload_profile_header
user_can_upload_user_card_background char User Can Upload User Card Background filters on the platform, writable, user.can_upload_user_card_background
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, user.created_at
user_custom_fields varchar2 itgen_dce_user_custom_fields writable The JSON text of the nested object.
user_email varchar2 itgen_dce_user_email filters on the platform, writable, user.email
user_gravatar_avatar_template varchar2 itgen_dce_user_gravatar_avatar_template filters on the platform, writable, user.gravatar_avatar_template
user_gravatar_avatar_upload_id int32 itgen_dce_user_gravatar_avatar_upload_id filters on the platform, writable, user.gravatar_avatar_upload_id
user_has_title_badges char User Has Title Badges filters on the platform, writable, user.has_title_badges
user_id decimal User ID filters on the platform, writable, user.id
user_ignored char User Ignored filters on the platform, writable, user.ignored
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, user.last_posted_at
user_last_seen_at varchar2 User Last Seen at filters on the platform, writable, user.last_seen_at
user_mailing_list_posts_per_day int32 User Mailing List Posts per Day filters on the platform, writable, user.mailing_list_posts_per_day
user_moderator char User Moderator filters on the platform, writable, user.moderator
user_muted char User Muted filters on the platform, writable, user.muted
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, user.pending_count
user_post_count int32 User Post Count filters on the platform, writable, user.post_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, user.profile_view_count
user_recent_time_read int32 User Recent Time Read filters on the platform, writable, user.recent_time_read
user_second_factor_backup_enabled char User Second Factor Backup Enabled filters on the platform, writable, user.second_factor_backup_enabled
user_second_factor_enabled char User Second Factor Enabled filters on the platform, writable, user.second_factor_enabled
user_staged char User Staged filters on the platform, writable, user.staged
user_system_avatar_template varchar2 User System Avatar Template filters on the platform, writable, user.system_avatar_template
user_time_read int32 User Time Read filters on the platform, writable, user.time_read
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, user.trust_level
user_uploaded_avatar_id varchar2 User Uploaded Avatar ID writable The JSON text of the nested object.
user_use_logo_small_as_avatar char User Use Logo Small as Avatar filters on the platform, writable, user.use_logo_small_as_avatar
user_user_notification_schedule_day_0_end_time int32 User User Notification Schedule Day 0 End Time filters on the platform, writable, user.user_notification_schedule.day_0_end_time
user_user_notification_schedule_day_0_start_time int32 User User Notification Schedule Day 0 Start Time filters on the platform, writable, user.user_notification_schedule.day_0_start_time
user_user_notification_schedule_day_1_end_time int32 User User Notification Schedule Day 1 End Time filters on the platform, writable, user.user_notification_schedule.day_1_end_time
user_user_notification_schedule_day_1_start_time int32 User User Notification Schedule Day 1 Start Time filters on the platform, writable, user.user_notification_schedule.day_1_start_time
user_user_notification_schedule_day_2_end_time int32 User User Notification Schedule Day 2 End Time filters on the platform, writable, user.user_notification_schedule.day_2_end_time
user_user_notification_schedule_day_2_start_time int32 User User Notification Schedule Day 2 Start Time filters on the platform, writable, user.user_notification_schedule.day_2_start_time
user_user_notification_schedule_day_3_end_time int32 User User Notification Schedule Day 3 End Time filters on the platform, writable, user.user_notification_schedule.day_3_end_time
user_user_notification_schedule_day_3_start_time int32 User User Notification Schedule Day 3 Start Time filters on the platform, writable, user.user_notification_schedule.day_3_start_time
user_user_notification_schedule_day_4_end_time int32 User User Notification Schedule Day 4 End Time filters on the platform, writable, user.user_notification_schedule.day_4_end_time
user_user_notification_schedule_day_4_start_time int32 User User Notification Schedule Day 4 Start Time filters on the platform, writable, user.user_notification_schedule.day_4_start_time
user_user_notification_schedule_day_5_end_time int32 User User Notification Schedule Day 5 End Time filters on the platform, writable, user.user_notification_schedule.day_5_end_time
user_user_notification_schedule_day_5_start_time int32 User User Notification Schedule Day 5 Start Time filters on the platform, writable, user.user_notification_schedule.day_5_start_time
user_user_notification_schedule_day_6_end_time int32 User User Notification Schedule Day 6 End Time filters on the platform, writable, user.user_notification_schedule.day_6_end_time
user_user_notification_schedule_day_6_start_time int32 User User Notification Schedule Day 6 Start Time filters on the platform, writable, user.user_notification_schedule.day_6_start_time
user_user_notification_schedule_enabled char User User Notification Schedule Enabled filters on the platform, writable, user.user_notification_schedule.enabled
user_user_option_allow_private_messages char User User Option Allow Private Messages filters on the platform, writable, user.user_option.allow_private_messages
user_user_option_auto_track_topics_after_msecs int32 User User Option Auto Track Topics After Milliseconds filters on the platform, writable, user.user_option.auto_track_topics_after_msecs
user_user_option_automatically_unpin_topics char User User Option Automatically Unpin Topics filters on the platform, writable, user.user_option.automatically_unpin_topics
user_user_option_digest_after_minutes int32 User User Option Digest After Minutes filters on the platform, writable, user.user_option.digest_after_minutes
user_user_option_dynamic_favicon char User User Option Dynamic Favicon filters on the platform, writable, user.user_option.dynamic_favicon
user_user_option_email_digests char User User Option Email Digests filters on the platform, writable, user.user_option.email_digests
user_user_option_email_in_reply_to char User User Option Email in Reply To filters on the platform, writable, user.user_option.email_in_reply_to
user_user_option_email_level int32 User User Option Email Level filters on the platform, writable, user.user_option.email_level
user_user_option_email_messages_level int32 User User Option Email Messages Level filters on the platform, writable, user.user_option.email_messages_level
user_user_option_email_previous_replies int32 User User Option Email Previous Replies filters on the platform, writable, user.user_option.email_previous_replies
user_user_option_enable_allowed_pm_users char User User Option Enable Allowed PM Users filters on the platform, writable, user.user_option.enable_allowed_pm_users
user_user_option_enable_defer char itgen_dce_user_user_option_enable_defer filters on the platform, writable, user.user_option.enable_defer
user_user_option_enable_quoting char User User Option Enable Quoting filters on the platform, writable, user.user_option.enable_quoting
user_user_option_external_links_in_new_tab char User User Option External Links in New Tab filters on the platform, writable, user.user_option.external_links_in_new_tab
user_user_option_hide_profile_and_presence char User User Option Hide Profile and Presence filters on the platform, writable, user.user_option.hide_profile_and_presence
user_user_option_include_tl0_in_digests char User User Option Include TL0 in Digests filters on the platform, writable, user.user_option.include_tl0_in_digests
user_user_option_like_notification_frequency int32 User User Option Like Notification Frequency filters on the platform, writable, user.user_option.like_notification_frequency
user_user_option_mailing_list_mode char User User Option Mailing List Mode filters on the platform, writable, user.user_option.mailing_list_mode
user_user_option_mailing_list_mode_frequency int32 User User Option Mailing List Mode Frequency filters on the platform, writable, user.user_option.mailing_list_mode_frequency
user_user_option_new_topic_duration_minutes int32 User User Option New Topic Duration Minutes filters on the platform, writable, user.user_option.new_topic_duration_minutes
user_user_option_notification_level_when_replying int32 User User Option Notification Level When Replying filters on the platform, writable, user.user_option.notification_level_when_replying
user_user_option_skip_new_user_tips char User User Option Skip New User Tips filters on the platform, writable, user.user_option.skip_new_user_tips
user_user_option_text_size varchar2 User User Option Text Size filters on the platform, writable, user.user_option.text_size
user_user_option_text_size_seq int32 User User Option Text Size Seq filters on the platform, writable, user.user_option.text_size_seq
user_user_option_theme_key_seq int32 User User Option Theme Key Seq filters on the platform, writable, user.user_option.theme_key_seq
user_user_option_title_count_mode varchar2 User User Option Title Count Mode filters on the platform, writable, user.user_option.title_count_mode
user_user_option_user_id int32 User User Option User ID filters on the platform, writable, user.user_option.user_id
user_username varchar2 User Name filters on the platform, writable, 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.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

All changes of the driver, 26.0 to 27.0