Users
Query information regarding users.
View-Specific Information
Select
The driver will use the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the driver.
- Id supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Users WHERE Id = '3152079000000150015'
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique numeric identifier for the user. |
| FirstName | String | The first name of the user. |
| LastName | String | The last name of the user. |
| FullName | String | The full name of the user. |
| String | The email of the user. | |
| RoleName | String | The name of the role the user has. |
| RoleId | String | The Id of the role the user has. |
| ProfileName | String | The name of the profile the user has. |
| ProfileId | String | The Id of the profile the user has. |
| Country | String | The country where the user is situated. |
| City | String | The city where the user is situated. |
| Street | String | The street where the user is situated. |
| State | String | The state where the user is situated. |
| Zip | String | The zip where the user is situated. |
| Alias | String | The alias of the user. |
| Signature | String | The signature of the user. |
| NameFormat | String | The format of the name of the user. |
| PersonalAccount | Boolean | Whether this user has a personal account or not. |
| DefaultTabGroup | String | The default tab group for this user. |
| CountryLocale | String | The default country locale of the user. |
| Fax | String | The fax of the user. |
| Website | String | The website of the user. |
| Mobile | String | The mobile phone number of the user. |
| Phone | String | The phone number of the user. |
| Dob | String | The date of birth of the user. |
| Status | String | The status of the user. |
| Confirm | Boolean | Whether this user has confirmed his email or not. |
| Language | String | The Language of the user. |
| Locale | String | The locale of the user. |
| TimeFormat | String | The default time format of the user. |
| DateFormat | String | The default date format of the user. |
| DecimalSeparator | String | The locale of the default decimal separator of the user. |
| TimeZone | String | The time zone of the user. |
| Zuid | String | The default ZUID of the user. |
| Territories | String | A comma separeted string of the user's territories. |
| CreatedByName | String | The name of the user who created this user. |
| CreatedById | String | The id of the user who created this user. |
| CreatedAt | Datetime | The time this user was created. |
| ModifiedByName | String | The name of the user who modified this user. |
| ModifiedById | String | The id of the user who modified this user. |
| ModifiedAt | Datetime | The time this user was last modified. |
| CustomizeInfoNotesDesc | String | The Customize info notes description. |
| CustomizeInfoShowRightPanel | Boolean | The Customize info show right panel. |
| CustomizeInfoShowLeftPanel | Boolean | The Customize info show left panel. |
| CustomizeInfoBcView | String | The Customize info bc view. |
| CustomizeInfoShowHome | Boolean | The Customize info show home. |
| CustomizeInfoShowDetailView | Boolean | The Customize info show detail view. |
| CustomizeInfoUnpinRecentItem | String | The Customize info unpin recent item. |
| Microsoft | Boolean | Represents if the user is a microsoft user. |
| ThemeBackground | String | The theme background. |
| ThemeNewBackground | String | The theme new background. |
| ThemeNormalTabBackground | String | The theme normal tab background. |
| ThemeNormalTabFontColor | String | The theme normal tab font color. |
| ThemeScreen | String | The theme screen. |
| ThemeSelectedTabBackground | String | The theme selected tab background. |
| ThemeSelectedTabBackground | String | The theme selected tab background. |
| ThemeType | String | The theme type. |
| ReportingToName | String | Represents the name of the user to whom the user reports to. |
| ReportingToId | String | Represents the id of the user to whom the user reports to. |
| Offset | Integer | Offset. |
| SandboxDeveloper | Boolean | Sandbox Developer. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Type | String | Limit the users returned to the ones of this type
The allowed values are AllUsers, ActiveUsers, DeactiveUsers, ConfirmedUsers, NotConfirmedUsers, DeletedUsers, ActiveConfirmedUsers, AdminUsers, ActiveConfirmedAdmins, CurrentUser. |