Navigation: Catalog: Discourse > Schemas > Schema: Admin > Tables

AdminUsersById

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

Catalog: Discourse

Schema: Admin

This is a read-only table function. The Discourse API may not support changing the data or the Invantive UniversalSQL driver for Discourse does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Discourse API.

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function AdminUsersById. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name	Data Type	Required	Default Value	Documentation
id		☑

Columns of Table Function

The columns of the table function AdminUsersById are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required
active	char	Active	☐
admin	char	Administrator	☐
approved_by	varchar2		☐
avatar_template	varchar2	Avatar Template	☐
badge_count	decimal	#Badges	☐
bounce_score	decimal	Bounce Score	☐
can_activate	char	Can Activate	☐
can_be_anonymized	char	Can Be Anonymized	☐
can_be_deleted	char	Can Be Deleted	☐
can_deactivate	char	Can Deactivate	☐
can_delete_all_posts	char	Can Delete All Posts	☐
can_disable_second_factor	char	Can Disable Second Factor	☐
can_grant_admin	char	Can Grant Admin	☐
can_grant_moderation	char	Can Grant Moderation	☐
can_impersonate	char	Can Impersonate	☐
can_revoke_admin	char	Can Revoke Admin	☐
can_revoke_moderation	char	Can Revoke Moderation	☐
can_send_activation_email	char	Can Send Activation Email	☐
can_view_action_logs	char	Can View Action Logs	☐
created_at_age	decimal	Created at Age	☐
created_at	varchar2	Created at	☐
days_visited	decimal	Days Visited	☐
flag_level	decimal	Flag Level	☐
flags_given_count	decimal	Flags Given Count	☐
flags_received_count	decimal	Flags Received Count	☐
full_suspend_reason	varchar2	Full Suspend Reason	☐
id	decimal	ID	☐
ip_address	varchar2	IP Address	☐
last_emailed_age	decimal	Last Emailed Age	☐
last_emailed_at	varchar2	Last Emailed at	☐
last_seen_age	decimal	Last Seen Age	☐
last_seen_at	varchar2	Last Seen at	☐
like_count	decimal	#Likes	☐
like_given_count	decimal	Like Given Count	☐
manual_locked_trust_level	varchar2		☐
moderator	char	Moderator	☐
name	varchar2	Name	☐
post_count	decimal	#Posts	☐
posts_read_count	decimal	Posts Read Count	☐
primary_group_id	varchar2		☐
private_topics_count	decimal	Private Topics Count	☐
registration_ip_address	varchar2	Registration IP Address	☐
reset_bounce_score_after	varchar2		☐
silence_reason	varchar2		☐
silenced_by	varchar2		☐
single_sign_on_record	varchar2		☐
staged	char	Staged	☐
suspended_at	varchar2	Suspended at	☐
suspended_by_avatar_template	varchar2	Suspended by Avatar Template	☐
suspended_by_id	decimal	Suspended by ID	☐
suspended_by_username	varchar2	Suspended by Username	☐
suspended_till	varchar2	Suspended till	☐
suspended	char	Suspended	☐
time_read	decimal	Time Read	☐
title	varchar2	Title	☐
topic_count	decimal	#Topics	☐
topics_entered	decimal	Topics Entered	☐
trust_level	decimal	Trust Level	☐
user_fields_1	varchar2		☐
username_lower	varchar2	Username Lowercase	☐
username	varchar2	User Name	☐
warnings_received_count	decimal	Warnings Received Count	☐

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Please enable JavaScript to view this site.

Discourse Data Model

AdminUsersById

Parameters of Table Function

Columns of Table Function

Important Safety and Usage Information