Development questions
Write a SOQL query on FieldHistory (AccountHistory or OpportunityFieldHistory) to see who changed a specific field in the last 7 days.
Query the history object with a date literal filter and read who changed the field via CreatedBy.
soql
SELECT AccountId, Field, OldValue, NewValue, CreatedBy.Name, CreatedDate
FROM AccountHistory
WHERE Field = 'Industry' AND CreatedDate = LAST_N_DAYS:7
ORDER BY CreatedDate DESC
For Opportunities use OpportunityFieldHistory (with OpportunityId). Field history tracking must be enabled on the field.
soqlscenariofield-historyaudit
More Development questions
- What is an Apex Trigger in Salesforce and when should you use it over Flows?
- What is the difference between before triggers and after triggers?
- Explain all Trigger context variables (isInsert, isUpdate, isDelete, isUndelete, isBefore, isAfter, isExecuting, size, operationType).
- What is the difference between Trigger.new and Trigger.old?
- In which trigger events are Trigger.new and Trigger.newMap available?
- In which trigger events are Trigger.old and Trigger.oldMap available?