SecurityGroupsManagement

Create, update, delete, and query information on security groups

テーブル固有の情報

WHERE 句で任意の条件を使用して、Security Groups Management テーブルをクエリできます。本製品はSuiteCRM API を使用して結果をフィルタリングします。

SELECT * FROM [Security Groups Management] WHERE [Not Inheritable] = true

書き込み可能なカラムを指定して、Security Group を作成します。

INSERT INTO [Security Groups Management] (Name, [Not Inheritable]) VALUES ('Test Group', false)

Id を指定して、書き込み可能なSecurity Group カラムを更新できます。

UPDATE [Security Groups Management] SET [Not Inheritable] = true WHERE Id = 'Test123'

Id を指定して、Security Group を削除します。

DELETE FROM [Security Groups Management] WHERE Id = 10003


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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Rows@Next	String	Identifier for the next page of results. Do not set this value manually.