List of all retool users

Account & User Management
1

Current plan level (Free, Team, Business, or Enterprise: Retool pricing): Business
Monthly/Annual (if Team or Business): Monthly
Version of Retool (if self-hosted): self-hosted

Question / Description:

Building on this thread here: List of retool users - #3 by Tess

We would like to accomplish a similar thing. Having some form of tasks/todos that can be assigned to any available retool user.

@Tess mentioned the possibility to access the retool user DB on self-hosted. How? Any guidelines, docs, best-practices here? Demos?

Thanks!

2

Hello @perelin!

Since you are self hosted, you will either need to query the Postgres DB that holds the user data for your instance. This information will not be on Retool DB as you are self-hosted :sweat_smile:

First you will need to get the credentials for the database.

These credentials would have been set when you were first deploying retool to wherever you are hosting the servers.

Once you have these credentials, you can add this Postgres DB as a Resource to your Retool app.

From there, you will want to query the 'users' table. This may have a slightly different name depending on how you had this set up during deployment.

Once you have found the right table and queried it, then you can specify what information you need from the table holder users data (name/email, etc.).

1 Like