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 | Name of the ticket property whose value changed. | |
| Value | String | False | The previous or historical value of the property. | |
| SourceType | String | False | Indicates how the change was made, such as by user action, workflow, or integration. | |
| SourceId | String | False | Additional identifier related to the source of the change, if available. | |
| Timestamp | Datetime | False | Date and time when the property value was updated. | |
| TicketId | Long | False | Unique identifier of the ticket associated with this property history entry. |