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

# Users_UserFeatured_user_badge_idsByUsername: Discourse itgen_dce_users_userfeatured_user_badge_idsbyusername_plural

`read only` `REST`

- Catalog: `Discourse`
- Schema: `Users`
- Label: itgen_dce_users_userfeatured_user_badge_idsbyusername_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 `Users_UserFeatured_user_badge_idsByUsername` 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 |
|---|---|---|:---:|---|---|
| `admin` | `char` | Administrator | [ ] | writable, `::ancestor.admin` |  |
| `avatar_template` | `varchar2` | Avatar Template | [ ] | writable, `::ancestor.avatar_template` |  |
| `badge_count` | `decimal` | #Badges | [ ] | writable, `::ancestor.badge_count` |  |
| `can_edit` | `char` | Can Edit | [ ] | writable, `::ancestor.can_edit` |  |
| `can_edit_email` | `char` | Can Edit Email | [ ] | writable, `::ancestor.can_edit_email` |  |
| `can_edit_name` | `char` | Can Edit Name | [ ] | writable, `::ancestor.can_edit_name` |  |
| `can_edit_username` | `char` | Can Edit Username | [ ] | writable, `::ancestor.can_edit_username` |  |
| `can_send_private_message_to_user` | `char` | Can Send Private Message to User | [ ] | writable, `::ancestor.can_send_private_message_to_user` |  |
| `can_send_private_messages` | `char` | Can Send Private Messages | [ ] | writable, `::ancestor.can_send_private_messages` |  |
| `card_badge` | `varchar2` | itgen_dce_card_badge | [ ] | writable | The JSON text of the nested object. |
| `created_at` | `varchar2` | Created at | [ ] | writable, `::ancestor.created_at` |  |
| `custom_fields` | `varchar2` | Custom Fields | [ ] | writable | The JSON text of the nested object. |
| `id` | `decimal` | ID | [ ] | writable, `::ancestor.id` |  |
| `invited_by` | `varchar2` | Invited By | [ ] | writable | The JSON text of the nested object. |
| `last_posted_at` | `varchar2` | Last Posted at | [ ] | writable, `::ancestor.last_posted_at` |  |
| `last_seen_at` | `varchar2` | Last Seen at | [ ] | writable, `::ancestor.last_seen_at` |  |
| `moderator` | `char` | Moderator | [ ] | writable, `::ancestor.moderator` |  |
| `name` | `varchar2` | Name | [ ] | writable | The JSON text of the nested object. |
| `pending_count` | `decimal` | Pending Count | [ ] | writable, `::ancestor.pending_count` |  |
| `primary_group_flair_bg_color` | `varchar2` | itgen_dce_primary_group_flair_bg_color | [ ] | writable | The JSON text of the nested object. |
| `primary_group_flair_color` | `varchar2` | itgen_dce_primary_group_flair_color | [ ] | writable | The JSON text of the nested object. |
| `primary_group_flair_url` | `varchar2` | itgen_dce_primary_group_flair_url | [ ] | writable | The JSON text of the nested object. |
| `primary_group_name` | `varchar2` | Primary Group Name | [ ] | writable | The JSON text of the nested object. |
| `profile_view_count` | `decimal` | Profile View Count | [ ] | writable, `::ancestor.profile_view_count` |  |
| `title` | `varchar2` | Title | [ ] | writable | The JSON text of the nested object. |
| `trust_level` | `decimal` | Trust Level | [ ] | writable, `::ancestor.trust_level` |  |
| `uploaded_avatar_id` | `varchar2` | Uploaded Avatar ID | [ ] | writable | The JSON text of the nested object. |
| `username` | `varchar2` | User Name | [ ] | writable, `::ancestor.username` |  |
| `website_name` | `varchar2` | itgen_dce_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-D043">

##### Table function Discourse.Users.Users_UserFeatured_user_badge_idsByUsername is removed

A statement that reads Discourse.Users.Users_UserFeatured_user_badge_idsByUsername fails after the upgrade. It had 29 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)

