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

Table-Specific Information

Select

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

SELECT * FROM GroupSlaPolicies WHERE Id = '01HXV0PT0DMK4MTFNK9Y6ENFJA'

Insert

The Title and Filter columns are required to insert. This operation is allowed for logged-in users with the "admin" role only.

INSERT INTO GroupSlaPolicies (Title, Description, Position, Filter) VALUES('Title test', 'desc' ,3, '{"all":[{"field":"group_id","operator":"includes","value":[9634300495132]}]}

Update

You must specify the Id of the Group SLA policy to update it. This operation is allowed for logged-in users with the "admin" role only.

UPDATE GroupSlaPolicies SET Title = 'Updated title' WHERE Id = '01HXV6JCGCDZGJ851VPQZWMG1E'

Delete

You must specify the Id of the Group SLA policy to delete it. This operation is allowed for logged-in users with the "admin" role only.

DELETE FROM GroupSlaPolicies WHERE Id = '01HXV6JCGCDZGJ851VPQZWMG1E'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Automatically assigned when created.
Title	String	False		The title of the Group SLA policy.
Position	Integer	False		Position of the Group SLA policy. This position determines the order in which policies are matched to tickets. If not specified, the Group SLA policy is added at the last position.
Description	String	False		The description of the Group SLA policy.
PolicyMetrics	String	False		An array of policy metric objects associated with the Group SLA policy.
CreatedAt	Datetime	True		The time the Group SLA policy was created.
UpdatedAt	Datetime	True		The time of the last update of the Group SLA policy.
Filter	String	False		An object that describes the conditions a ticket must match for a Group SLA policy to be applied to the ticket.
Url	String	True		The URL of the Group SLA policy record.