Hello All,

I am trying to write Batch APEX Class to Join Lead with User.

I have added fields to the User object to hold the ID of the who the user was replaced by (Replaced_By_ID__c).

The scenario is an AE (User) leaves the company and is replaced by a new AE (User).

In my APEX Class I want to find the Leads that were owned by the departed AE (User)  by joining to User where User.Replaced_By_ID__c <> '' and User.Accounts_Traansferred__c = FALSE.

If I find a match I want to update Lead.OwnerID with User.Replaced_By_ID__c.

Unfortunately,  User.Replaced_By_ID__c and User.Accounts_Traansferred__c are unavailble.

Compile Error: Variable does not exist: Replaced_By_ID__c at line 14 column 25

Can someone help me? Please.

Here is my dumb code.

global class LeadTransferTEST04 implements Database.Batchable<sObject>{

    global integer recordsProcessed = 1;
    string NoValue = ' ';
    
    global Database.QueryLocator start(Database.BatchableContext bc){
       return Database.getQueryLocator('SELECT ID, OwnerID, Replaced_By_ID__c from Lead where OwnerID IN (SELECT ID FROM User WHERE Accounts_Transferred__c = FALSE and Replaced_By_ID__c <> NoValue)');
    }
        
    
    global void execute(Database.BatchableContext bc, List<Lead> scope){
        for(Lead l : scope){
      
            l.OwnerID = Replaced_By_ID__c;
        }
        update scope;        
    }
          
    global void finish(Database.BatchableContext bc){
     System.debug(recordsProcessed + ' records processed. Shazam!');
        AsyncApexJob job = [SELECT Id, Status, NumberOfErrors, 
            JobItemsProcessed,
            TotalJobItems, CreatedBy.Email
            FROM AsyncApexJob
            WHERE Id = :bc.getJobId()];
        // call some utility to send email
       // EmailUtils.sendMessage(a, recordsProcessed);
       // Send an email to the Apex job's submitter notifying of job completion.
       // Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
       // String[] toAddresses = new String[] {CreatedBy.Email};
       // mail.setToAddresses(toAddresses);
       // mail.setSubject('Apex Lead Transfer Job ' + a.Status);
       // mail.setPlainTextBody
       // ('Apex Lead Transfer Job has been completed. There were total of ' + a.TotalJobItems 
       //       + ' batches with ' + successCounter + ' success and ' + failureCounter
       //       + ' failures.');
       // Messaging.sendEmail(new Messaging.SingleEmailMessage[]{mail});
    }     
}