List Entries Value Changes

Includes the history of changes to list-specific field values, scoped to the list entry the change was made on. Only fields with change tracking enabled record changes. Changes to global fields are in persons_value_changes, companies_value_changes, and opportunities_value_changes. The entity a change is on is reached through list_entries_persons, list_entries_companies, and list_entries_opportunities. Field metadata is in the fields_metadata table (join field_id to fields_metadata.id). Name: v1_0.list_entries_value_changes

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)
`list_entry_id`	The ID of the list entry the change is scoped to
`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