Roles
Create, update, delete, and query the roles in SuiteCRM.
Table Specific Information
Select
You can query the Roles table using any criteria in the WHERE clause. The connector will use the SuiteCRM API to filter the results.
SELECT * FROM Roles WHERE Name LIKE '%test%' AND [Date Created] > '2017-10-09'
Insert
Create a Role by specifying any writable column.
INSERT INTO Roles (Name,[Modules]) VALUES ('Tester', 'AOS_Products')
Update
You can update any Role column that is writable, by specifying the Id.
UPDATE Roles SET [Modules] = 'Accounts' WHERE Id = 'Test123'
Delete
Remove a Role by specifying the Id.
DELETE FROM Roles WHERE Id = 10003
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier of the role. |
| CreatedById | String | True |
The Id of the user who created the record. |
| CreatedByName | String | True |
The Name of the user who created the record. |
| DateCreated | Datetime | True |
The date the record was entered. |
| DateModified | Datetime | True |
The date the record was last modified. |
| Deleted | Bool | False |
Whether the record is deleted. |
| Description | String | False |
The description of the role. |
| ModifiedById | String | True |
The Id of the user who last modified the record. |
| ModifiedByName | String | True |
The Name of the user who last modified the record. |
| Modules | String | False |
The modules the role has permission to access. |
| Name | String | False |
The name of the role. |
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 |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |