CustomFieldHistoryTracking
Shows every change made to selected custom fields, providing timestamps, old values, and new values for audit and compliance.
Table-Specific Information
Select
The driver uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.
- ModuleName supports the '=' operator.
- EntityId supports the '=' operator.
- FieldName supports the '=' operator.
- HistoryName supports the '=' operator.
All columns used in the criteria are required. Use FieldName to specify the actual name of the tracked custom field and HistoryName to specify the name of the history tracking section. If you want to retrieve data for a specific entity of a module specify EntityId in the criteria.
For example, the following query is processed server side:
SELECT * FROM [CustomFieldHistoryTracking] WHERE ModuleName = 'Leads' AND FieldName = 'pickListField' AND HistoryName = 'Pick List 1' SELECT * FROM [CustomFieldHistoryTracking] WHERE ModuleName = 'Leads' AND FieldName = 'pickListField' AND HistoryName = 'Pick List 1' AND EntityId = '12345665'
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique numeric identifier for the custom field tracking history entry. |
| ModuleName | String | The name of the module to which this custom field tracking entry belongs. |
| EntityId | String | The identifier of the record within the module to which this custom field tracking entry applies. |
| FieldName | String | The name of the custom field being tracked. |
| HistoryName | String | The name assigned to this history entry for the custom field. |
| FieldValue | String | The value of the custom field at the time of this history entry. |
| DurationDays | Integer | The number of days this field value remained unchanged. |
| ModifiedAt | Datetime | The date and time when the field value was last modified. |
| ModifiedById | String | The identifier of the user who modified the field value. |
| ModifiedByName | String | The name of the user who modified the field value. |
| CurrencySymbol | String | The currency symbol associated with the field value, if applicable. |
| ProcessFlow | Boolean | Indicates whether this value is part of a process flow. |
| Editable | Boolean | Indicates whether this historical field value can be edited. |
| Approved | Boolean | Indicates whether this historical field value has been approved. |