---
title: "UsersByUsername (Discourse)"
description: "itgen_dce_usersbyusername_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Users.UsersByUsername
original: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Users.UsersByUsername
updated: 2026-11-01T16:08:49Z
license: https://documentation.invantive.eu/en/
---

# 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` | `` | [x] |  |  |

## 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:

- [Discourse](/en/release-notes/drivers?driver=discourse)

### Changes of This Table, 26.0 to 27.0

<div class="rn-item" id="DCE-27.0-D042">

##### 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.

<div class="rn-action">

**What to Do**

Check statements, views and scripts that use it before the upgrade.

</div>

<div class="rn-chips">

- **can break a statement**
- importance 5

</div>

</div>

[All changes of the driver, 26.0 to 27.0](/en/release-notes/drivers?driver=discourse&step=26.0-to-27.0#discourse-26.0-to-27.0)

