User TableThis table contains all the users within CAM. Query the table by: select * from user limit 100 ^Use the users user Query type | Info |
|---|
Important: Don’t type users as the table name; this is an old antiquated table and you won’t get proper results. |
Column | Description |
|---|
id | Displays the row number of the entry in the user table | userId | Displays the user id associated to the user name. | userName | Displays the user name | emailId | Displays the user email Id | office | N/A | title | N/A | phone | N/A | location | N/A | isExternal | N/A | userType | Displays the user type (Internal/External) | subscriberId | Displays the tenant subscriber Id | system | Displays the external system name | documentDBName | Displays the database name | repositoryId | Displays the repository name | writeDate | Displays | flag | N/A | createdOn | Displays the user creation date | createdBy | N/A | modifiedOn | Displays the last update date | modifiedBy | Displays the user name who last updated the entry | metadata | N/A | sourceId | Displays the database name | repositoryName | Displays the repository name |
|