JDBC Driver for Zendesk

Build 23.0.8839

TicketSkips

Create and Query the TicketSkips in Zendesk. A skip is a record of when an agent skips over a ticket without responding to the end user. Skips are typically recorded while a play-only agent is in Guided mode.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the 本製品.
SELECT * FROM TicketSkips
SELECT * FROM TicketSkips WHERE UserId = '10478855687068'
SELECT * FROM TicketSkips WHERE TicketId = '21'

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 TicketId and Reason fields are required to insert. Allowed for Agents.

INSERT INTO TicketSkips (TicketId, Reason) VALUES ('22', 'This is the skipped ticket.')

To get the TicketIds of deleted tickets run this query:

GETDELETED FROM TicketSkips

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned upon creation.

TicketId Integer False

Tickets.Id

ID of the skipped ticket.

UserId Long True

Users.Id

ID of the skipping agent.

Ticket String True

The skipped ticket object.

Reason String False

Reason for skipping the ticket.

CreatedAt Datetime True

Time the skip was created.

UpdatedAt Datetime True

Time the skip was last updated.

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