TicketEvents
Returns ticket events, including child events, updater, and metadata details.
Table-Specific Information
Select
The following queries are processed server-side while other filters are processed client-side within the provider.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 |
The unique Id automatically assigned when the ticket event is created. | |
| TicketId | Integer | False |
Tickets.Id |
The ticket Id. |
| ChildEvents | String | False |
An array of child events associated with the ticket event. | |
| UpdaterId | Long | False |
The Id of the user who triggered the update. | |
| Timestamp | String | False |
The timestamp at which the event was created. | |
| Via | String | False |
The medium through which the event was created. | |
| SystemClient | String | False |
The client information associated with the system that generated the event. | |
| SystemLocation | String | False |
The location information associated with the system that generated the event. | |
| SystemLatitude | String | False |
The latitude coordinate associated with the system that generated the event. | |
| SystemLongitude | String | False |
The longitude coordinate associated with the system that generated the event. | |
| EventType | String | False |
The type of the ticket event. | |
| CreatedAt | Datetime | False |
The date and time when the ticket event record was created. | |
| Metadata | String | False |
The metadata associated with the ticket event. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| 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 start time for the most recent minute. |
| IncludeCommentText | Boolean |
Indicates whether comments are included in the event stream. By default, value is false. |