Query Ticket related information in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the connector.

SELECT * FROM TicketRelatedInformation where TicketId = '2826'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name	Type	References	Description
TicketId	Long	Tickets.id	The id of the Ticket.
TopicId	String		Related topic in the Web portal (deprecated feature).
JiraIssueIds	String		Jira issues Id.
FollowupSourceIds	String		Sources to follow up.
FromArchive	Boolean		Is true if the current ticket is archived.
Incidents	Integer		A count of related incident occurrences.
Url	String		Url.
Twitter	String		X (formerly Twitter) information associated with the ticket