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 connector.

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.