TicketPropertiesHistory
Returns the history of changes made to ticket properties, useful for auditing ticket updates.
Select
The PropertyName filter is required to retrieve data from this view. When querying TicketPropertiesHistory, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operators are = and IN.SELECT * FROM TicketPropertiesHistory WHERE PropertyName = 'Create Date'
Columns
| Name | Type | References | Filterable | Description |
| PropertyName | String | True | The name of the property. | |
| Value | String | False | The historical value of the property. | |
| SourceType | String | False | The method by which the property was changed. | |
| SourceId | String | False | Additional data related to the source. May not be populated for all sources. | |
| Timestamp | Datetime | False | Datetime when the property was updated. | |
| TicketId | Long | False | The ticket identifier. |