JDBC Driver for Zendesk

Build 24.0.8963

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

SELECT * FROM TicketMetrics WHERE TicketId = '123' 

SELECT * FROM TIcketMetrics WHERE TicketId IN (SELECT Id FROM Tickets)

To get the TicketIds of deleted tickets run this query:

GETDELETED FROM TicketMetrics

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.

TicketId [KEY] Integer False

Tickets.Id

The ID of the associated ticket.

GroupStations Integer False

Number of groups this ticket passed through.

AssigneeStations Integer False

Number of assignees this ticket had.

Reopens Integer False

Total number of times the ticket was reopened.

Replies Integer False

Total number of times ticket was replied to.

AssigneeUpdatedAt Datetime False

When the assignee last updated the ticket.

RequesterUpdatedAt Datetime False

When the requester last updated the ticket.

StatusUpdatedAt Datetime False

When the status was last updated.

InitiallyAssignedAt Datetime False

When the ticket was initially assigned.

AssignedAt Datetime False

When the ticket was last assigned.

SolvedAt Datetime False

When the ticket was solved.

LatestCommentAddedAt Datetime False

When the latest comment was added.

FirstResolutionTimeCalendar Int False

Number of minutes to the first resolution time inside and out of business hours.

FirstResolutionTimeBusiness Int False

Number of minutes to the first resolution time inside and out of business hours.

ReplyTimeCalendar Int False

Number of minutes to the first reply inside and out of business hours.

ReplyTimeBusiness Int False

Number of minutes to the first reply inside and out of business hours.

FullResolutionTimeCalendar Int False

Number of minutes to the full resolution inside and out of business hours.

FullResolutionTimeBusiness Int False

Number of minutes to the full resolution inside and out of business hours.

AgentWaitTimeCalendar Int False

Number of minutes the agent spent waiting inside and out of business hours.

AgentWaitTimeBusiness Int False

Number of minutes the agent spent waiting inside and out of business hours.

RequesterWaitTimeCalendar Int False

Number of minutes the requester spent waiting inside and out of business hours.

RequesterWaitTimeBusiness Int False

Number of minutes the requester spent waiting inside and out of business hours.

CreatedAt Datetime False

When this record was created.

UpdatedAt Datetime False

When this record last got updated.

Url String False

The API url of this ticket metric.

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