Roles
Query information regarding roles.
Table-Specific Information
Select
The driver uses 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 Roles WHERE Id = '1234567890123456789'
Insert
To create a role, you must at least supply a value for the Name column.INSERT INTO Roles (Name) VALUES ('Test');
Update
Specify the Id in the WHERE clause when executing an update in this table.
UPDATE Roles SET Description = 'test' WHERE Id = '1234567890123456789';
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
A unique numeric identifier for the role. |
| Name | String | False |
The name of the role. |
| DisplayLabel [KEY] | String | True |
The way the role is displayed in the UI. |
| ReportingToName | String | True |
The name of the role this role reports to. |
| ReportingToId | String | False |
The Id of the role this role reports to. |
| CreatedByID | String | True |
Represents the ID of the user that created this role. |
| CreatedByName | String | True |
Represents the name of the user that created this role. |
| CreatedTime | Datetime | True |
Represents the date and time at which the role was created. |
| ModifiedByID | String | True |
Represents the ID of the user who modified this role last. |
| ModifiedByName | String | True |
Represents the name of the user who modified this role last. |
| ModifiedTime | Datetime | True |
Represents the date and time at which the role was modified last. |
| ForecastManagerName | String | True |
The forecast manager's name. |
| ForecastManagerId | String | False |
The forecast manager's Id. |
| ShareWithPeers | Boolean | False |
Indicates whether the users with the current role have permission to share records. |
| Description | String | False |
Represents the description of the role, if any. |