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 | . |