SlaPolicies
Create, update, delete, and query SlaPolicies in Zendesk.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the 本製品.SELECT * FROM SlaPolicies SELECT * FROM SlaPolicies WHERE Id = '18393257431953'
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 Title field and atleast one field from either FilterAll or FilterAny is required to insert. A suitable combination of Field, Operator and Value is required for insertion in FilterAll and FilterAny. Here is a list of the possible combinations: "https://developer.zendesk.com/documentation/ticketing/reference-guides/conditions-reference/#shared-conditions". Allowed for admins.
INSERT INTO SlaPoliciesFilterAll#temp(Field, Operator, Value) VALUES('type', 'is', 'incident') INSERT INTO SlaPoliciesFilterAny#temp(Field, Operator, Value) VALUES('type', 'is', 'problem') INSERT INTO SlaPolicies(Title, Description, FilterAll, FilterAny) values('Test', 'This is the test description', 'SlaPoliciesFilterAll#temp', 'SlaPoliciesFilterAny#temp')
Update
You must specify the Id of the SlaPolicies to update it. FilterAll and FilterAny aggregate columns support duplicate values in the object, so in order to update these fields, you must specifty the whole aggregate object. All fields that are not readonly (readonly="false" in the table) are optional. Allowed for admins.
INSERT INTO SlaPoliciesFilterAll#temp(Field, Operator, Value) Values('type', 'is', 'task') INSERT INTO SlaPoliciesFilterAll#temp(Field, Operator, Value) Values('type', 'is', 'incident') INSERT INTO SlaPoliciesFilterAll#temp(Field, Operator, Value) Values('group_id', 'is', '18285074736529') UPDATE SlaPolicies SET Title='Updated Title', FilterAll='SlaPoliciesFilterAll#temp' WHERE Id = '18393257431953'
Delete
You must specify the Id of the group to delete it. Allowed for admins.
DELETE FROM SlaPolicies WHERE Id=18392949131793
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
Automatically assigned. | |
Title | String | False |
The title of the SLA policy. | |
Description | String | False |
The description of the SLA policy. | |
CreatedAt | Datetime | True |
When this locale was created. | |
UpdatedAt | Datetime | True |
When this locale last got updated. | |
Position | Integer | True |
Position of the SLA policy, determines the order they will be matched. If not specified, SLA Policy is added as the last position. | |
FilterAll | String | False |
An object that describes the conditions that a ticket must match in order for an SLA policy to be applied to that ticket. | |
FilterAny | String | False |
An object that describes the conditions that a ticket must match in order for an SLA policy to be applied to that ticket. | |
PolicyMetrics | String | False |
An object that describes the metric targets for each value of the priority field. |