JDBC Driver for Zendesk

Build 22.0.8462

TicketAudits

Query TicketAudits in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the driver.
SELECT * FROM TicketAudits

SELECT * FROM TicketAudits WHERE TicketId = '123'

SELECT * FROM TicketAudits WHERE TicketId = '123' AND Id = '456'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type References Description
Id [KEY] Long Automatically assigned when creating audits.
TicketId Integer

Tickets.Id

The ID of the associated ticket.
AuthorId Long

Users.Id

The user who created the audit.
CreatedAt Datetime The time the audit was created.
Metadata String Metadata for the audit, custom and system data.
ViaChannel String This object explains how this audit was created. This does not update on every request.
ViaSource String This object explains how this audit was created. This does not update on every request.
Events String The Array of Events that happened in this Audit.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462