JDBC Driver for Zendesk

Build 24.0.8963

GroupSlaPolicies

Create, Update, Delete and Query Group SLA Policies in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the 本製品.
SELECT * FROM GroupSlaPolicies

SELECT * FROM GroupSlaPolicies WHERE Id = '01HXV0PT0DMK4MTFNK9Y6ENFJA'

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 and Filter fields are required to insert. Allowed for admins.

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 GroupSlaPolicy to update. Allowed for admins.

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

Delete

You must specify the Id of the GroupSlaPolicy to delete it. Allowed for admins.

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

Array of policy metric objects.

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

URL of the Group SLA policy record.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963