JDBC Driver for Zendesk

Build 22.0.8462

TicketComments

Query TicketComments belonging to a specified ticket in Zendesk.

Table Specific Information

Select

The Ticket Id is required to query this view. The following queries are processed server side.

SELECT * FROM TicketComments

SELECT * FROM TicketComments WHERE TicketId='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type References Description
Id [KEY] Long Automatically assigned when the ticket is created.
TicketId Integer

Tickets.Id

The id of the ticket the comment belongs to.
AuthorId Long

Users.Id

The id of the comment author.
Type String Comment or VoiceComment.
Body String The comment string.
CreatedAt Datetime The time the comment was created.
HtmlBody String The comment formatted as HTML.
PlainBody String The comment as plain text.
IsPublic Boolean True if a public comment; false if an internal note. The initial value set on ticket creation persists for any additional comment unless you change it.
ViaChannel String This tells you how the ticket or event was created. Examples: 'web', 'mobile', 'rule', 'system'.
ViaSource String .
MetadataCustom String .
MetadataSystemClient String .
MetadataSystemIpAddres String .
MetadataSystemLatitude String .
MetadataSystemLongitude String .
MetadataSystemLocation String .

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