// Check a specific record Account acc = [SELECT Id, Name, Status__c FROM Account WHERE Id = '001xx000003GYk1']; System.debug('Name: ' + acc.Name); System.debug('Status: ' + acc.Status__c); // Fix data // acc.Status__c = 'Active'; // update acc;

trigger AccountTrigger on Account (before insert) { for(Account acc : Trigger.new) { if(acc.AnnualRevenue == null) { acc.addError('Annual Revenue is required.'); } // Field-level error if(acc.Phone == null) { acc.Phone.addError('Phone is mandatory.'); } } }

// ❌ WRONG — SOQL in loop for(Account acc : accounts) { Contact c = [SELECT Id FROM Contact WHERE AccountId = :acc.Id]; } // ✅ CORRECT — One SOQL outside loop Map<Id, List<Contact>> cMap = new Map<Id, List<Contact>>(); for(Contact c : [SELECT Id, AccountId FROM Contact WHERE AccountId IN :accountIds]) { if(!cMap.containsKey(c.AccountId)) cMap.put(c.AccountId, new List<Contact>()); cMap.get(c.AccountId).add(c); } for(Account acc : accounts) { List<Contact> cons = cMap.get(acc.Id); // No SOQL! }

// ❌ WRONG User u = new User(...); insert u; // Setup object Account a = new Account(...); insert a; // MIXED_DML error! // ✅ CORRECT @future public static void createUser(String name) { User u = new User(...); insert u; // Separate transaction — no conflict }

// ❌ WRONG insert account; // DML done Http h = new Http(); // ERROR! // ✅ CORRECT trigger AccTrigger on Account (after insert) { MyService.callERP( new Map<Id,Account>(Trigger.new).keySet() ); // @future(callout=true) method }

// ❌ WRONG — NPE if no Contact or no Email String email = acc.Contacts[0].Email.toUpperCase(); // ✅ CORRECT — Null checks if(acc.Contacts != null && !acc.Contacts.isEmpty() && acc.Contacts[0].Email != null) { String email = acc.Contacts[0].Email.toUpperCase(); } // ✅ BETTER — Safe navigation operator String email = acc?.Contacts?.get(0)?.Email?.toUpperCase();

System.debug('SOQL: ' + Limits.getQueries() + '/' + Limits.getLimitQueries()); System.debug('DML: ' + Limits.getDmlStatements()); System.debug('CPU: ' + Limits.getCpuTime() + 'ms'); System.debug('Heap: ' + Limits.getHeapSize() + ' bytes'); // Conditional check if((Limits.getLimitQueries() - Limits.getQueries()) > 10) { // Safe to query more }

// ❌ VULNERABLE String q = 'SELECT Id FROM Account WHERE Name = \'' + userInput + '\''; // Attacker enters: ' OR Name != '' → ALL accounts! // ✅ SAFE — Bind variable List<Account> accs = [SELECT Id FROM Account WHERE Name = :userInput]; // ✅ SAFE — Escape for dynamic SOQL String safe = String.escapeSingleQuotes(userInput);

try { insert account; } catch(DmlException e) { for(Integer i = 0; i < e.getNumDml(); i++) { System.debug('Type: ' + e.getDmlType(i)); // FIELD_CUSTOM_VALIDATION_EXCEPTION System.debug('Field: ' + e.getDmlFieldNames(i)); System.debug('Message: ' + e.getDmlMessage(i)); } }

// ❌ WRONG — DML in loop for(Contact c : contacts) { c.Phone = '9999'; update c; // 1 DML per contact! } // ✅ CORRECT — Bulkified for(Contact c : contacts) { c.Phone = '9999'; // Memory only } update contacts; // ONE DML for all

// Without security — bypasses FLS List<Account> accs = [SELECT Id, Salary__c FROM Account]; // With security — respects user FLS List<Account> accs = [SELECT Id, Salary__c FROM Account WITH SECURITY_ENFORCED]; // Modern alternative SObjectAccessDecision d = Security.stripInaccessible( AccessType.READABLE, accounts);

@isTest static void testUserAccess() { User rep = [SELECT Id FROM User WHERE Username = 'rep@company.com']; System.runAs(rep) { // Respects rep's sharing rules List<Account> visible = [SELECT Id FROM Account]; System.debug('Rep sees: ' + visible.size()); } }

// Query deleted records List<Account> deleted = [SELECT Id, Name FROM Account WHERE IsDeleted = true ALL ROWS]; // Undelete undelete deleted; // OR: App Launcher → Recycle Bin → select → Undelete

// Apex merge Account master = [SELECT Id FROM Account WHERE Id = :masterId]; List<Account> dupes = [SELECT Id FROM Account WHERE Id IN :dupeIds]; merge master dupes; // Dupes deleted, related records (Contacts, Opps) // automatically transferred to master

trigger ContactTrigger on Contact (before insert, after insert) { Migration_Config__mdt cfg = [ SELECT Is_Active__c FROM Migration_Config__mdt WHERE Label = 'ContactTrigger' LIMIT 1 ]; if(!cfg.Is_Active__c) return; // Skip ALL logic! new ContactTriggerHandler().run(); } // Disable: set Is_Active__c = false in Custom Metadata // No code deployment needed!

// Identify affected records List<Account> affected = [ SELECT Id, Status__c FROM Account WHERE LastModifiedDate >= 2026-05-21T10:00:00Z AND LastModifiedDate <= 2026-05-21T11:00:00Z AND Status__c = 'Wrong_Value' ]; // Fix for(Account a : affected) { a.Status__c = 'Correct_Value'; } update affected;

// Contact CSV with External ID relationship FirstName,LastName,Account:SAP_Customer_No__c John,Smith,CUST-12345 Jane,Doe,CUST-67890 // Data Loader finds Account WHERE SAP_Customer_No__c = CUST-12345 // Links Contact automatically — no SF Account ID needed!

HttpRequest req = new HttpRequest(); req.setEndpoint('callout:XYZ_ERP/orders'); // Named Credential req.setMethod('GET'); req.setTimeout(30000); Http h = new Http(); HttpResponse res = h.send(req);

@isTest public class MockHTTP implements HttpCalloutMock { public HTTPResponse respond(HTTPRequest req) { HTTPResponse res = new HTTPResponse(); res.setStatusCode(200); res.setBody('{"status":"success"}'); return res; } } @isTest static void testIt() { Test.setMock(HttpCalloutMock.class, new MockHTTP()); Test.startTest(); MyService.doCallout(); Test.stopTest(); }

// REST API — all limits with remaining GET /services/data/v62.0/limits // Response: // "DailyApiRequests":{"Max":1000000,"Remaining":950000} // "DailyBulkApiRequests":{"Max":150000000,"Remaining":149000000}

// Check subscriber status SELECT Id, ExternalId, LastError, Position, RetryCount, Status, Topic FROM EventBusSubscriber // Status: Running=healthy, Stopped/Error=problem // LastError: exact delivery failure reason

POST /services/data/v62.0/composite { "allOrNone": true, "compositeRequest": [ {"method":"POST","referenceId":"NewAcc", "url":"/services/data/v62.0/sobjects/Account", "body":{"Name":"ABC Pharma"}}, {"method":"POST","referenceId":"NewCon", "url":"/services/data/v62.0/sobjects/Contact", "body":{"LastName":"Smith", "AccountId":"@{NewAcc.id}"}} ] }

public class IntegrationLogger { public static void log(String source, Integer status, String msg, Id recId) { Integration_Error__c err = new Integration_Error__c( Source__c = source, HTTP_Status__c = status, Error_Message__c = msg, Record_Id__c = recId, Status__c = 'Pending Retry' ); Database.insert(err, false); // Never throws! } }

GET /services/data/v62.0/sobjects/Account/{id} // Read POST /services/data/v62.0/sobjects/Account // Create PATCH /services/data/v62.0/sobjects/Account/{id} // Update DELETE /services/data/v62.0/sobjects/Account/{id} // Delete GET /services/data/v62.0/query?q=SELECT+Id+FROM+Account GET /services/data/v62.0/limits // API usage POST /services/data/v62.0/composite // Batch

// Record-Triggered Flow: // Trigger: Case status changed to 'Pending Customer' // Scheduled Path: 5 days after LastModifiedDate // Condition: Status still = 'Pending Customer'? // If yes: Update Status = 'Closed' // Send email: 'Case auto-closed' // OR Escalation Rule: // Case Age > 5 days AND Status = Pending Customer // Action: Update Status = Closed

// Check coverage via SOQL SELECT ApexClassOrTriggerId, NumLinesCovered, NumLinesUncovered FROM ApexCodeCoverageAggregate WHERE ApexClassOrTrigger.Name = 'MyClass' // Developer Console: Tests menu → Run All // Red lines = uncovered paths needing test methods // Fix: add test for uncovered scenario @isTest static void testErrorPath() { Account acc = new Account(Name='Test'); try { insert acc; } catch(Exception e) { System.assert(e.getMessage() != null); } }

# Create scratch org sfdx force:org:create -f config/project-scratch-def.json \ -a MyScratchOrg --durationdays 7 # Push local source sfdx force:source:push # Open in browser sfdx force:org:open # Clean slate: perfect for isolated feature dev + testing

Order of Execution (simplified): 1. System Validation Rules 2. Before Triggers 3. Custom Validation Rules 4. Duplicate Rules 5. After Triggers 6. Assignment Rules 7. Auto-Response Rules 8. Workflow Rules (field updates) 9. Flows 10. Escalation Rules 11. Roll-up Summaries 12. Async: @future, Platform Events

// Step 1: Deactivate the bad Flow // Step 2: Find affected records List<Account> affected = [ SELECT Id, Status__c FROM Account WHERE LastModifiedDate >= 2026-05-21T10:00:00Z AND LastModifiedDate <= 2026-05-21T11:00:00Z AND Status__c = 'Wrong_Value' ]; // Step 3: Fix (test on 5 records first!) for(Account a : affected) { a.Status__c = 'Correct'; } update affected;

// One trigger per object — handler pattern trigger AccountTrigger on Account ( before insert, after insert, before update, after update) { // Single entry point new AccountTriggerHandler().run(); } // No multiple triggers fighting each other // All logic organized in one handler class