Returns the history of changes made to order properties for auditing purposes.

View Specific Information

SELECT

The PropertyName filter is required to retrieve data from this view. When querying OrderPropertiesHistory, filtering can be applied to columns marked as "Filterable." For these columns, the supported server-side operators are = and IN.

SELECT * FROM OrderPropertiesHistory;
SELECT * FROM OrderPropertiesHistory WHERE PropertyName = 'hs_createdate';

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.
OrderId	Long		False	The order identifier.