[SalesForce] Trigger on history tracking object

I have history tracking enabled for a custom object. Can I write trigger trigger on the new History tracking of my custom object? I am not getting such example from google nether do I get somewhere it is not possible.

Best Answer

You can have Apex Batch Job where you can Query the history and add your logic.

Use Below Query to get the rows

Select ID,Field,OldValue,NewValue,createddate From CucstomObject__History 
where Field = 'CustomObjectFieldName' and parentId = :CucstomObject.Id 
order by createddate

Related Solutions

[SalesForce] Apex: Is there a way to Identify if history tracking is enabled on the field or not

Since Winter '16 this can be achieved using the IsFieldHistoryTracked field on FieldDefinition.

To get all tracked fields on Steps__c you can use:

SELECT QualifiedApiName FROM FieldDefinition WHERE EntityDefinition.QualifiedApiName = 'Steps__c' AND IsFieldHistoryTracked = true

[SalesForce] History tracking of object

I can't find this in Apex, but I can find it in the Tooling API and in the Metadata API.

For the Tooling API, check the CustomField object: https://developer.salesforce.com/docs/atlas.en-us.api_tooling.meta/api_tooling/tooling_api_objects_customfield.htm

For the Metadata API, there is, for each field on an object, a "trackHistory" attribute. https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/customfield.htm

Andy Fawcett has written an Apex wrapper for the Metadata API. For more information, see https://andyinthecloud.com/category/metadata-api/ and https://github.com/financialforcedev/apex-mdapi.

(I'd go with the Metadata API and would use the wrapper. It's an easy deploy from the GitHub repository.

Best Answer

Related Solutions

[SalesForce] Apex: Is there a way to Identify if history tracking is enabled on the field or not

[SalesForce] History tracking of object

Related Topic