JDBC Driver for Zendesk

Build 22.0.8462

TicketMetricEvents

Query TicketMetricEvents in Zendesk.

Table Specific Information

Select

To query all ticket metric events, use the following query:

SELECT * FROM TicketMetricEvents

To query ticket metric events, starting from a given time, use the following example:

SELECT * FROM TicketMetricEvents WHERE StartTime = '2017-02-05'

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 References Description
Id [KEY] Long Automatically assigned when the record is created.
TicketId Integer

Tickets.Id

Id of the associated ticket.
Metric String One of the following: agent_work_time, pausable_update_time, periodic_update_time, reply_time, requester_wait_time, or resolution_time.
InstanceId Long The instance of the metric associated with the event.
Type String When this locale last got updated.
Time Datetime The time the event occurred.
Sla String Available if type is apply_sla. The SLA policy and target being enforced on the ticket and metric in question, if any.
Status String Available if type is update_status. Minutes since the metric has been open. See status.
Deleted Boolean Available if type is breach. In general, you can ignore any breach event when deleted is true.

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