Opportunities Value Changes

Includes the history of changes to global field values on opportunities. Only fields with change tracking enabled record changes. Changes to list-specific fields are not in this table; they are in list_entries_value_changes, which reaches an opportunity through list_entries_opportunities. Field metadata is in the fields_metadata table (join field_id to fields_metadata.id). Name: v1_0.opportunities_value_changes Deleted and merged records are covered in Deletes & Merges.

Grant access to the share only to users who are authorized to view all organization data. There are no per-user or per-role visibility filters applied at the share level.

Columns

Column	Description
`id`	The field value change’s unique identifier
`field_id`	The ID of the field whose value changed (join to fields_metadata.id)
`opportunity_id`	The ID of the opportunity the change is on
`changer_id`	The person ID of the user that made the change (null for system-generated changes or when the user has been deleted)
`changed_at`	The date that the change was recorded
`action_type`	The type of change (add, update, or delete)
`value`	The new value for add/update changes, or the removed value for delete changes, as a one-entry JSON object keyed by field_id — the same shape as a custom_fields entry. Person, company, and dropdown values are rendered as the referenced ID (null when the referenced row has since been deleted). Use the value_type on the joined fields_metadata row to interpret it
`value_display`	Display text snapshot captured at change time for person, company, and dropdown values (person name, company name, or dropdown option text); null for other value types
`is_deleted`	Whether the field value change has been deleted
`last_updated_at`	Timestamp when this record was last updated

Getting Started

Example Queries

V1_0

Changelog

Columns

​Columns

Columns