JDBC Driver for Zendesk

Build 24.0.8963

TicketMetricEvents

Queries 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'

To get the TicketIds of deleted tickets run this query:

GETDELETED FROM TicketMetricEvents

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 the record is created.

TicketId Integer False

Tickets.Id

The Id of the associated ticket.

Metric String False

One of the following: agent_work_time, pausable_update_time, periodic_update_time, reply_time, requester_wait_time, or resolution_time.

InstanceId Long False

The instance of the metric associated with the event.

Type String False

When this locale last got updated.

Time Datetime False

The time the event occurred.

Sla String False

Available if type is apply_sla. The SLA policy and target being enforced on the ticket and the metric in question, if any.

Status String False

Available if type is update_status. Minutes since the metric has been open. See status.

Deleted Boolean False

Available if type is breach. In general, you can ignore any breach event when deleted is true.

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