TicketEvents
Query TicketEvents in Zendesk.
Table Specific Information
Select
The following queries are processed server side while other filters are processed client side within the 本製品.SELECT * FROM TicketEvents SELECT * FROM TicketEvents WHERE StartTime = '2023-10-11' SELECT * FROM TicketEvents WHERE StartTime = '2023-10-11' AND Include = true SELECT * FROM TicketEvents WHERE Include = true
To get the TicketIds of deleted tickets run this query:
GETDELETED FROM TicketEvents
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 | ReadOnly | References | Description |
Id [KEY] | Long | False |
Automatically assigned when Ticket Event is created. | |
TicketId | Integer | False |
Tickets.Id |
The ticket Id. |
ChildEvents | String | False |
Array of the Child Events. | |
UpdaterId | Long | False |
Updater Id. | |
Timestamp | String | False |
Timestamp at which event is created. | |
Via | String | False |
The medium through which event is created. | |
SystemClient | String | False |
System client information. | |
SystemLocation | String | False |
System location information. | |
SystemLatitude | String | False |
System latitude information. | |
SystemLongitude | String | False |
System longitude information. | |
EventType | String | False |
Type of the Event. | |
CreatedAt | Datetime | False |
When this record was created. | |
Metadata | String | False |
The metadata of the event. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
StartTime | Datetime |
The time to start the incremental export from. Must be at least one minute in the past. If not provided, it will take the starttime for the most recent minute. |
Include | Boolean |
If true, it will include the comments in the event stream. By default, value is false. |