SOQL Query on History Objects

SOQL Tutorial What is SOQL SOQL Real Life Scenario SOQL Naming Conventions SOQL WHERE SOQL Comparison Operators SOQL Logical Operators SOQL ORDER BY SOQL LIMIT SOQL OFFSET SOQL Aggregate Functions SOQL GROUP BY SOQL HAVING SOQL Relationship Queries SOQL Date Literals SOQL Date Functions SOQL History Objects SOQL Sharing Objects SOQL in APEX Apex Variables in SOQL Queries Static and Dynamic SOQL SOQL return types SOQL Governor Limits Efficient SOQL Queries

We can turn on history tracking on some standard and any custom object for specific fields. In case that field is changed, a history record is created, specifying the old value, and the new value, and who updated it.

SOQL can query these records as well:

Query on standard object’s history Object:

SELECT Field, OldValue , NewValue, CreatedBy.Name
FROM ContactHistory
WHERE ContactId = '003aertyulopuioQWE'

In the above query, all contact history records are fetched for contact whose id is ‘003aertyulopuioQWE’

Query on custom object’s history Object:

SELECT Field, OldValue , NewValue, Parent.Name
FROM Clinic__History
WHERE Parent.Name = 'Orlando'

Important

Note that for Contact the history object is ContactHistory, whereas for Clinc__c, it is Clinic__History.

History Object fields:

• ParentId is the Id of the record.
• Field is the name of the field.
• OldValue is the old value of the field.
• NewValue is the new value of the field.