Apex Intermediate Progress | ( Lessons)

Lesson: 12 | Merging Duplicate Accounts

Notes
Key Points

Notes

public class FindAccountAndMerge {

    public static void mergeAccountByNameAndPhone(String accountName, String phone) {
        try {
            // Fetch the list of accounts with the given name and phone
            List<Account> accList = [SELECT Id, Name, Phone FROM Account WHERE Name = :accountName AND Phone = :phone ORDER BY CreatedDate ASC];

            System.debug('List of Accounts: ' + accList);

            if (accList.size() > 1) {
                // The first account in the list will be the master account
                Account masterAccount = accList[0];

                for (Integer i = 1; i < accList.size(); i++) {
                    Account duplicateAccount = accList[i];
                    try {
                        // Merge the duplicate account into the master account
                        Database.merge(masterAccount, duplicateAccount);
                    } catch (Exception e) {
                        System.debug('Failed to merge Account: ' + duplicateAccount.Id + ' due to: ' + e.getMessage());
                    }
                }
            } else {
                System.debug('No duplicates found or only one account exists.');
            }
        } catch (Exception e) {
            System.debug('Error in merging accounts: ' + e.getMessage());
        }
    }
}

You need to login to have access to the quizzes.

Mastered by 0 users.

Apex Intermediate

A. Apex DML Operations (8 lessons)

B. Apex Classes (17 lessons)

C. Apex Triggers (9 lessons)

D. Apex Exceptions (11 lessons)

E. Asynchronous Apex (6 lessons)

F. SOSL (10 lessons)

G. Testing Apex (9 lessons)

H. Apex Fast Recap (142 lessons)

I. Build Apex Coding Skills (64 lessons)

J. Miscellaneous (17 lessons)

You need to complete all the quizzes before certification.

Go to top

Login to your account

Lesson: 12 | Merging Duplicate Accounts

Notes

Apex Intermediate