Returns SLA policies, including filter conditions and policy metric details.

Table-Specific Information

Select

The following queries are processed server-side while other filters are processed client-side within the provider.

SELECT * FROM SlaPolicies
SELECT * FROM SlaPolicies WHERE Id = '18393257431953'

Insert

The Title column and at least 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. See a list of the possible combinations here. This operation is allowed for logged-in users with the "admin" role only.

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 SLA policies to update it. FilterAll and FilterAny aggregate columns support duplicate values in the object. Thus, in order to update these fields, you must specify the whole aggregate object. All fields that are not readonly are optional. This operation is allowed for logged-in users with the "admin" role only.

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. This operation is allowed for logged-in users with the "admin" role only.

DELETE FROM SlaPolicies WHERE Id=18392949131793

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The Id automatically assigned when the SLA policy is created.
Title	String	False		The title of the SLA policy.
Description	String	False		The description of the SLA policy.
CreatedAt	Datetime	True		The date and time when the SLA policy was created.
UpdatedAt	Datetime	True		The date and time when the SLA policy was last updated.
Position	Integer	True		The position of the SLA policy that determines the order in which policies are matched. If not specified, the SLA policy is added in the last position.
FilterAll	String	False		An object that describes the conditions that all must be met in order for the SLA policy to be applied.
FilterAny	String	False		An object that describes the conditions where any one must be met in order for the SLA policy to be applied.
PolicyMetrics	String	False		An object that describes the metric targets for each value of the priority field.