TicketAudits
Query TicketAudits in Zendesk.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the 本製品.SELECT * FROM TicketAudits WHERE TicketId = '123' SELECT * FROM TicketAudits WHERE TicketId = '123' AND Id = '456'
To get the TicketIds of deleted tickets run this query:
GETDELETED FROM TicketAudits
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 | ReadOnly | References | Description |
Id [KEY] | Long | False |
Automatically assigned when creating audits. | |
TicketId | Integer | False |
Tickets.Id |
The ID of the associated ticket. |
AuthorId | Long | False |
Users.Id |
The user who created the audit. |
CreatedAt | Datetime | False |
The time the audit was created. | |
Metadata | String | False |
Metadata for the audit, custom and system data. | |
ViaChannel | String | False |
This object explains how this audit was created. This does not update on every request. | |
ViaSource | String | False |
This object explains how this audit was created. This does not update on every request. | |
Events | String | False |
The Array of Events that happened in this Audit. |