TicketComments

Query TicketComments belonging to a specified ticket in Zendesk.

Table Specific Information

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


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	False		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	False		The id of the ticket audit record.
Type	String	False		Comment or VoiceComment.
Body	String	False		The comment string.
CreatedAt	Datetime	False		The time the comment was created.
HtmlBody	String	False		The comment formatted as HTML.
PlainBody	String	False		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	False		This tells you how the ticket or event was created. Examples: 'web', 'mobile', 'rule', 'system'.
ViaSource	String	False		.
MetadataCustom	String	False		.
MetadataSystemClient	String	False		.
MetadataSystemIpAddres	String	False		.
MetadataSystemLatitude	String	False		.
MetadataSystemLongitude	String	False		.
MetadataSystemLocation	String	False		.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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.