invantive documentation
Invantive Support ForumsLog In / Sign Up

AdminUsers_GroupsById: Discourse Admin Users Groups by ID

read only REST

  • Catalog: Discourse
  • Schema: Admin
  • Label: Admin Users Groups by ID

Get a specific user by id. Returns more info than the public user route.

Can only retrieve data.

Summary

Get a specific user by id. Returns more info than the public user route.

API Source

  • Endpoint: /admin/users/{id}.json
  • Operation: get /admin/users/{id}.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
id ``

Table Columns

The columns of the table AdminUsers_GroupsById 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
active char Active filters on the platform, writable, ::ancestor.active
admin char Administrator filters on the platform, writable, ::ancestor.admin
allow_membership_requests char Allow Membership Requests writable, allow_membership_requests
approved_by varchar2 itgen_dce_approved_by writable The JSON text of the nested object.
automatic char Automatic writable, automatic
automatic_membership_email_domains varchar2 Automatic Membership Email Domains writable The JSON text of the nested object.
automatic_membership_retroactive char Automatic Membership Retroactive writable, automatic_membership_retroactive
avatar_template varchar2 Avatar Template filters on the platform, writable, ::ancestor.avatar_template
badge_count decimal #Badges filters on the platform, writable, ::ancestor.badge_count
bio_cooked varchar2 Bio Cooked writable The JSON text of the nested object.
bio_raw varchar2 Bio Raw writable The JSON text of the nested object.
bounce_score decimal Bounce Score filters on the platform, writable, ::ancestor.bounce_score
can_activate char Can Activate filters on the platform, writable, ::ancestor.can_activate
can_be_anonymized char Can Be Anonymized filters on the platform, writable, ::ancestor.can_be_anonymized
can_be_deleted char Can Be Deleted filters on the platform, writable, ::ancestor.can_be_deleted
can_deactivate char Can Deactivate filters on the platform, writable, ::ancestor.can_deactivate
can_delete_all_posts char Can Delete All Posts filters on the platform, writable, ::ancestor.can_delete_all_posts
can_disable_second_factor char Can Disable Second Factor filters on the platform, writable, ::ancestor.can_disable_second_factor
can_grant_admin char Can Grant Admin filters on the platform, writable, ::ancestor.can_grant_admin
can_grant_moderation char Can Grant Moderation filters on the platform, writable, ::ancestor.can_grant_moderation
can_impersonate char Can Impersonate filters on the platform, writable, ::ancestor.can_impersonate
can_revoke_admin char Can Revoke Admin filters on the platform, writable, ::ancestor.can_revoke_admin
can_revoke_moderation char Can Revoke Moderation filters on the platform, writable, ::ancestor.can_revoke_moderation
can_send_activation_email char Can Send Activation Email filters on the platform, writable, ::ancestor.can_send_activation_email
can_view_action_logs char Can View Action Logs filters on the platform, writable, ::ancestor.can_view_action_logs
created_at varchar2 Created at filters on the platform, writable, ::ancestor.created_at
created_at_age decimal Created at Age filters on the platform, writable, ::ancestor.created_at_age
days_visited decimal Days Visited filters on the platform, writable, ::ancestor.days_visited
default_notification_level decimal Default Notification Level writable, default_notification_level
display_name varchar2 Display Name writable, display_name
flag_level decimal Flag Level filters on the platform, writable, ::ancestor.flag_level
flags_given_count decimal Flags Given Count filters on the platform, writable, ::ancestor.flags_given_count
flags_received_count decimal Flags Received Count filters on the platform, writable, ::ancestor.flags_received_count
flair_bg_color varchar2 Flair Background Color writable The JSON text of the nested object.
flair_color varchar2 Flair Color writable The JSON text of the nested object.
flair_url varchar2 Flair URL writable The JSON text of the nested object.
full_name varchar2 Full Name writable The JSON text of the nested object.
full_suspend_reason varchar2 Full Suspend Reason filters on the platform, writable, ::ancestor.full_suspend_reason
grant_trust_level varchar2 Grant Trust Level writable The JSON text of the nested object.
has_messages char Has Messages writable, has_messages
id decimal ID writable, id
id_2 decimal ID 2 filters on the platform, writable, ::ancestor.id
incoming_email varchar2 Incoming Email writable The JSON text of the nested object.
ip_address varchar2 IP Address filters on the platform, writable, ::ancestor.ip_address
last_emailed_age decimal Last Emailed Age filters on the platform, writable, ::ancestor.last_emailed_age
last_emailed_at varchar2 Last Emailed at filters on the platform, writable, ::ancestor.last_emailed_at
last_seen_age decimal Last Seen Age filters on the platform, writable, ::ancestor.last_seen_age
last_seen_at varchar2 Last Seen at filters on the platform, writable, ::ancestor.last_seen_at
like_count decimal #Likes filters on the platform, writable, ::ancestor.like_count
like_given_count decimal Like Given Count filters on the platform, writable, ::ancestor.like_given_count
manual_locked_trust_level varchar2 Manual Locked Trust Level writable The JSON text of the nested object.
membership_request_template varchar2 Membership Request Template writable The JSON text of the nested object.
mentionable_level decimal Mentionable Level writable, mentionable_level
messageable_level decimal Messageable Level writable, messageable_level
moderator char Moderator filters on the platform, writable, ::ancestor.moderator
name varchar2 Name writable, name
name_2 varchar2 Name 2 filters on the platform, writable, ::ancestor.name
post_count decimal #Posts filters on the platform, writable, ::ancestor.post_count
posts_read_count decimal Posts Read Count filters on the platform, writable, ::ancestor.posts_read_count
primary_group char Primary Group writable, primary_group
primary_group_id varchar2 Primary Group ID writable The JSON text of the nested object.
private_topics_count decimal Private Topics Count filters on the platform, writable, ::ancestor.private_topics_count
public_admission char Public Admission writable, public_admission
public_exit char Public Exit writable, public_exit
registration_ip_address varchar2 Registration IP Address filters on the platform, writable, ::ancestor.registration_ip_address
reset_bounce_score_after varchar2 Reset Bounce Score After writable The JSON text of the nested object.
silence_reason varchar2 Silence Reason writable The JSON text of the nested object.
silenced_by varchar2 Silenced By writable The JSON text of the nested object.
single_sign_on_record varchar2 Single Sign on Record writable The JSON text of the nested object.
staged char Staged filters on the platform, writable, ::ancestor.staged
suspended char Suspended filters on the platform, writable, ::ancestor.suspended
suspended_at varchar2 Suspended at filters on the platform, writable, ::ancestor.suspended_at
suspended_by_avatar_template varchar2 Suspended by Avatar Template filters on the platform, writable, ::ancestor.suspended_by.avatar_template
suspended_by_id decimal Suspended by ID filters on the platform, writable, ::ancestor.suspended_by.id
suspended_by_username varchar2 Suspended by Username filters on the platform, writable, ::ancestor.suspended_by.username
suspended_till varchar2 Suspended till filters on the platform, writable, ::ancestor.suspended_till
time_read decimal Time Read filters on the platform, writable, ::ancestor.time_read
title varchar2 Title writable The JSON text of the nested object.
title_2 varchar2 Title 2 writable The JSON text of the nested object.
topic_count decimal #Topics filters on the platform, writable, ::ancestor.topic_count
topics_entered decimal Topics Entered filters on the platform, writable, ::ancestor.topics_entered
trust_level decimal Trust Level filters on the platform, writable, ::ancestor.trust_level
user_count decimal #Users writable, user_count
user_fields_1 varchar2 User Fields 1 writable The JSON text of the nested object.
username varchar2 User Name filters on the platform, writable, ::ancestor.username
username_lower varchar2 Username Lowercase filters on the platform, writable, ::ancestor.username_lower
visibility_level decimal Visibility Level writable, visibility_level
warnings_received_count decimal Warnings Received Count filters on the platform, writable, ::ancestor.warnings_received_count

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.Admin.AdminUsers_GroupsById is removed

A statement that reads Discourse.Admin.AdminUsers_GroupsById fails after the upgrade. It had 88 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