JDBC Driver for Zendesk

Build 24.0.8963

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 本製品.
SELECT * FROM TicketAudits WHERE TicketId = '123'

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

To get the TicketIds of deleted tickets run this query:

GETDELETED FROM TicketAudits

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 ReadOnly References Description
Id [KEY] Long False

Automatically assigned when creating audits.

TicketId Integer False

Tickets.Id

The ID of the associated ticket.

AuthorId Long False

Users.Id

The user who created the audit.

CreatedAt Datetime False

The time the audit was created.

Metadata String False

Metadata for the audit, custom and system data.

ViaChannel String False

This object explains how this audit was created. This does not update on every request.

ViaSource String False

This object explains how this audit was created. This does not update on every request.

Events String False

The Array of Events that happened in this Audit.

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