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 connector.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
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. |