CustomFieldHistoryTracking
Returns a history of changes made to custom fields across modules, supporting field-level audit trails.
Table-Specific Information
Select
The provider 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 provider.
- 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 | Unique identifier for the custom field history record. |
| ModuleName | String | Name of the module associated with this custom field tracking entry. |
| EntityId | String | Identifier of the specific record within the module to which this history applies. |
| FieldName | String | Name of the custom field being tracked. |
| HistoryName | String | Label or identifier for this specific instance of field history. |
| FieldValue | String | Value of the custom field at the time of this historical entry. |
| DurationDays | Integer | Number of days the field remained in the recorded value or stage. |
| ModifiedAt | Datetime | Timestamp indicating when the field value was last modified. |
| ModifiedById | String | Identifier of the user who last modified the field value. |
| ModifiedByName | String | Full name of the user who last modified the field value. |
| CurrencySymbol | String | Currency symbol associated with the field value, if applicable. |
| ProcessFlow | Boolean | Indicates whether this historical value is part of a process flow. |
| Editable | Boolean | Indicates whether this historical value is editable. |
| Approved | Boolean | Indicates whether this historical value has been approved. |