Returns the history of changes to deal properties for auditing and historical analysis.

Select

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

SELECT * FROM DealPropertiesHistory WHERE PropertyName = 'Create Date'

Columns

Name	Type	References	Filterable	Description
PropertyName	String		True	Name of the deal property whose historical value is being recorded.
Value	String		False	Previous value of the property before it was updated.
SourceType	String		False	Method or source responsible for changing the property's value, such as API, user action, or workflow.
SourceId	String		False	Additional identifier related to the source of the change. Might be empty depending on the source type.
Timestamp	Datetime		False	Timestamp indicating when the property value was updated.
DealId	Long		False	Unique identifier of the deal associated with this property history entry.