Lesson: 41 | Delete Inactive Accounts

Apex Trigger

trigger DeleteInactiveAccounts on Account (after update) {
    Set<Id> inactiveAccountIds = new Set<Id>();

    for (Account account : Trigger.new) {
        if (account.Active__C != Trigger.oldMap.get(account.Id).Active__C && account.Active__C =='No') {
            inactiveAccountIds.add(account.Id);
        }
    }

    delete [SELECT Id FROM Account WHERE Id IN :inactiveAccountIds];
}