JDBC Driver for Zendesk

Build 24.0.8963

TicketEvents

Query TicketEvents in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the 本製品.
SELECT * FROM TicketEvents
SELECT * FROM TicketEvents WHERE StartTime = '2023-10-11'
SELECT * FROM TicketEvents WHERE StartTime = '2023-10-11' AND Include = true
SELECT * FROM TicketEvents WHERE Include = true

To get the TicketIds of deleted tickets run this query:

GETDELETED FROM TicketEvents

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.

Columns

Name Type ReadOnly References Description
Id [KEY] Long False

Automatically assigned when Ticket Event is created.

TicketId Integer False

Tickets.Id

The ticket Id.

ChildEvents String False

Array of the Child Events.

UpdaterId Long False

Updater Id.

Timestamp String False

Timestamp at which event is created.

Via String False

The medium through which event is created.

SystemClient String False

System client information.

SystemLocation String False

System location information.

SystemLatitude String False

System latitude information.

SystemLongitude String False

System longitude information.

EventType String False

Type of the Event.

CreatedAt Datetime False

When this record was created.

Metadata String False

The metadata of the event.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
StartTime Datetime

The time to start the incremental export from. Must be at least one minute in the past. If not provided, it will take the starttime for the most recent minute.

Include Boolean

If true, it will include the comments in the event stream. By default, value is false.

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