TicketComments
Returns comments belonging to a specified ticket, including comment body, author, channel, and metadata details.
Table-Specific Information
Select
The TicketId is required to query this table. 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
Insert
TicketId and Body are required to insert a comment.
INSERT INTO TicketComments (TicketId, AuthorId, Body, IsPublic) VALUES ('2547', '963428390', 'Moving to resolved', true)
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
The unique Id automatically assigned when the comment 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 associated ticket audit record. | |
| Type | String | True |
The type of the comment, such as Comment or VoiceComment. | |
| Body | String | False |
The plain text body of the comment. | |
| CreatedAt | Datetime | True |
The date and time when the comment was created. | |
| HtmlBody | String | True |
The comment formatted as HTML. | |
| PlainBody | String | True |
The comment as plain text. | |
| IsPublic | Boolean | False |
Indicates whether the comment is public. The initial value set on ticket creation persists for any additional comment unless you change it. | |
| ViaChannel | String | True |
The channel through which the ticket or event was created, such as web, mobile, rule, or system. | |
| ViaSource | String | True |
The source details of how the ticket or event was created. | |
| MetadataCustom | String | True |
Custom metadata associated with the comment. | |
| MetadataSystemClient | String | True |
The client application that created the comment. | |
| MetadataSystemIpAddress | String | True |
The IP address of the system that created the comment. | |
| MetadataSystemLatitude | String | True |
The latitude of the location where the comment was created. | |
| MetadataSystemLongitude | String | True |
The longitude of the location where the comment was created. | |
| MetadataSystemLocation | String | True |
The location where the comment was created. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| UpdatedAt | Datetime |
The date and time when the comment was updated. |
| ReferenceNumber | String |
A reference number that can be used for temp table insertion. |