SecurityGroupsManagement
Create, update, delete, and query information on security groups
Table Specific Information
Select
You can query the Security Groups Management table using any criteria in the WHERE clause. The connector will use the SuiteCRM API to filter the results.
SELECT * FROM [Security Groups Management] WHERE [Not Inheritable] = true
Insert
Create a Security Group by specifying any writable column.
INSERT INTO [Security Groups Management] (Name, [Not Inheritable]) VALUES ('Test Group', false)
Update
You can update any Security Group column that is writable, by specifying the Id.
UPDATE [Security Groups Management] SET [Not Inheritable] = true WHERE Id = 'Test123'
Delete
Remove a Security Group by specifying the Id.
DELETE FROM [Security Groups Management] WHERE Id = 10003
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier of the security group. |
| Assignedto | String | True |
The user name of the user assigned to the record. |
| AssignedUserId | String | False |
The Id of the user assigned to the record. |
| 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 created. |
| DateModified | Datetime | True |
The date the record was last modified. |
| Deleted | Bool | False |
The record deletion indicator. |
| Description | String | False |
Description for the security group |
| LBL_SECURITYGROUP_NONINHERITABLE | Bool | True |
Whether the group is inheritable |
| LBL_securitygroup_noninherit_id | String | True |
Non-Inheritance Id |
| 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. |
| Name | String | False | |
| NotInheritable | Bool | False |
Whether the group is inheritable |
| PrimaryGroup | Bool | True |
Whether the group is primary |
| UserName | String | True |
User fields for the group |
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. |