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 WHERE TicketId = '123'
To get the TicketIds of deleted tickets run this query:
GETDELETED FROM TicketComments
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
Automatically assigned when the ticket is created. | |
| TicketId | Integer | False |
Tickets.Id |
The id of the ticket the comment belongs to. |
| AuthorId | Long | False |
Users.Id |
The id of the comment author. |
| AuditId | Long | True |
The id of the ticket audit record. | |
| Type | String | True |
Comment or VoiceComment. | |
| Body | String | False |
The comment string. | |
| CreatedAt | Datetime | True |
The time the comment was created. | |
| HtmlBody | String | True |
The comment formatted as HTML. | |
| PlainBody | String | True |
The comment as plain text. | |
| IsPublic | Boolean | False |
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 | True |
This tells you how the ticket or event was created. Examples: 'web', 'mobile', 'rule', 'system'. | |
| ViaSource | String | True |
. | |
| MetadataCustom | String | True |
. | |
| MetadataSystemClient | String | True |
. | |
| MetadataSystemIpAddres | String | True |
. | |
| MetadataSystemLatitude | String | True |
. | |
| MetadataSystemLongitude | String | True |
. | |
| MetadataSystemLocation | String | True |
. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| UpdatedAt | Datetime |
The time of the comment was updated. |
| ReferenceNumber | String |
Reference number which can be use while doing temp table insertion. |