Retrieves the history of ticket property changes, useful for auditing customer support data.

Select

The PropertyName filter is required to retrieve data from this view:

SELECT * FROM TicketPropertiesHistory WHERE PropertyName = 'Create Date'

Columns

Name	Type	References	Filterable	Description
PropertyName	String		False	The internal name of the ticket property that was changed.
Value	String		False	The previous or historical value of the specified property.
SourceType	String		False	The origin of the property change, such as user update, workflow, or integration.
SourceId	String		False	Additional metadata about the source of the change. May be blank depending on the source type.
Timestamp	Datetime		False	The date and time when the property was last updated.
TicketId	Long		False	Unique identifier of the ticket associated with the property change.