ManagementPermissionGroups
Create, Update, Delete and Query the Management Permission Groups in Zendesk. A management permission group defines which agents can create, update, archive, and publish articles. It consists of a set of privileges, each of which is mapped to a user segment. Agents receive whichever privileges are associated with the user segments they belong to.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the 本製品.SELECT * FROM ManagementPermissionGroups SELECT * FROM ManagementPermissionGroups WHERE Id = '19162149101585'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.
Insert
The Name column is required to insert. All fields that are not readonly (readonly="false" in the table) are optional for insert. Allowed for Help Center managers.
INSERT INTO ManagementPermissionGroups (Name, Edit) VALUES ('Test', '19162093613969, 19236810082193')
Update
You must specify the Id of the ManagementPermissionGroup to update. All fields that are not readonly (readonly="false" in the table) are optional for insert. Allowed for Help Center managers.
UPDATE ManagementPermissionGroups SET Name = 'UpdatedName' WHERE Id = '19239392699537'
Delete
You must specify the Id of the ManagementPermissionGroup to delete it. Allowed for Help Center managers.
DELETE FROM ManagementPermissionGroups WHERE Id = '19239392699537'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
Automatically assigned when the permission group is created. | |
BuiltIn | Boolean | True |
Whether the permission group is built-in. Built-in permission groups cannot be modified. | |
Name | String | False |
Permission group name. | |
Edit | String | False |
The ids of user segments that have edit privileges. For insertion and updation provide these values separated by comma. | |
Publish | String | False |
The ids of user segments that have publish privileges. For insertion and updation provide these values separated by comma. | |
CreatedAt | Datetime | True |
When the permission group was created. | |
UpdatedAt | Datetime | True |
When the permission group was last updated. |