[Salesforce] The Sobject Crusade: AccountHistory

Back to the Sobject Crusade list.

Source: AccountHistory

This object supports Field Tracking History on the Account object.

To track fields on the Account object, go to Setup > Accounts > Fields and click the Set History Tracking button.

Then click on the Enable Account History flag and select all fields to be tracked:

From now on the selected fields will be tracked in the Account History related list:

Here is the corresponding query:

Select Id, Field, NewValue, OldValue From AccountHistory Where AccountId = '00124000003vaBu'

History tracking has few limitations:

• You can track upto 20 standard and custom fields per custom object
• The field history data is retained for up to 18 months
• Changes to fields with more than 255 characters are tracked as edited, and their old and new values are not recorded
• Tracked field values are not automatically translated
• Changes to custom field labels that have been translated via the Translation Workbench are shown in the locale of the user viewing the History related list
• Changes to date fields, number fields, and standard fields are shown in the locale of the user viewing the History related list
• If a trigger causes a change on an object the current user doesn’t have permission to edit, that change is not tracked because field history honors the permissions of the current user
• Additional field history increases beyond your current limits require the purchase of the Field Audit Trail add-on, following the Spring '15 release