JDBC Driver for Zendesk

Build 20.0.7587

TicketMetrics

Query TicketMetrics 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 TicketMetrics

SELECT * FROM TicketMetrics WHERE Id = '123'

SELECT * FROM TicketMetrics WHERE TicketId = '123' 

SELECT * FROM TIcketMetrics WHERE TicketId in (SELECT Id from Tickets)

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 Description
Id [KEY] Long Automatically assigned.
TicketId Integer The ID of the associated ticket.
GroupStations Integer Number of groups this ticket passed through.
AssigneeStations Integer Number of assignees this ticket had.
Reopens Integer Total number of times the ticket was reopened.
Replies Integer Total number of times ticket was replied to.
AssigneeUpdatedAt Datetime When the assignee last updated the ticket.
RequesterUpdatedAt Datetime When the requester last updated the ticket.
StatusUpdatedAt Datetime When the status was last updated.
InitiallyAssignedAt Datetime When the ticket was initially assigned.
AssignedAt Datetime When the ticket was last assigned.
SolvedAt Datetime When the ticket was solved.
LatestCommentAddedAt Datetime When the latest comment was added.
FirstResolutionTimeCalendar Int Number of minutes to the first resolution time inside and out of business hours.
FirstResolutionTimeBusiness Int Number of minutes to the first resolution time inside and out of business hours.
ReplyTimeCalendar Int Number of minutes to the first reply inside and out of business hours.
ReplyTimeBusiness Int Number of minutes to the first reply inside and out of business hours.
FullResolutionTimeCalendar Int Number of minutes to the full resolution inside and out of business hours.
FullResolutionTimeBusiness Int Number of minutes to the full resolution inside and out of business hours.
AgentWaitTimeCalendar Int Number of minutes the agent spent waiting inside and out of business hours.
AgentWaitTimeBusiness Int Number of minutes the agent spent waiting inside and out of business hours.
RequesterWaitTimeCalendar Int Number of minutes the requester spent waiting inside and out of business hours.
RequesterWaitTimeBusiness Int Number of minutes the requester spent waiting inside and out of business hours.
CreatedAt Datetime When this record was created.
UpdatedAt Datetime When this record last got updated.
Url String The API url of this ticket metric.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587