Sign Up ›
  • Mounika Varma
  • NEWBIE
  • 0 Points
  • Member since 2021
  • Chatter
    Feed
  • 0
    Best Answers
  • 2
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 2
    Replies
4 replies

My Requirement is I had Created a TotalAmount field on Account Object, I need to sum of the opportunity amount for all the opportunities for that account. using Batch class

This is my code and i am not getting results 

global class batchclass implements Database.Batchable<sObject>,Database.Stateful{
    global Decimal sum;
     /* Batch class constructor */
    global batchclass(){}
    //Start method
    global Database.QueryLocator start(Database.BatchableContext BC)
    {
        String query='SELECT id, Amount from Opportunity';
         return Database.getQueryLocator(query);
        }

    //Excute method
    
global void execute(Database.BatchableContext BC, List<Opportunity> scope)
{
    //Excution logic
    //List<Opportunity> opp= new List<Opportunities>();
    AggregateResult[] gr=[select id,TotalAmount__c,(select amount from Opportunities) from account where id IN:accountIds];
        system.debug(gr);
    for(AggregateResult ag:gr){
        sum = (Decimal)ag.get('optyamt');
        system.debug(''+sum);
    }
    
}
      global void finish(Database.BatchableContext BC){
            // Finish logic
          system.debug(''+sum); 
       }
}
9 replies

Hi Everyone, I have Created a field called Total Amount on Account and I need to Populate the Total Amount on Account with the sum of the opportunity amounts for all the opportunities for that account Using Batch class

I have tried this  below  code its not working 
someone please help me writing the batch class and test class for this scenerio

global class batchclass implements Database.Batchable<sObject>,Database.Stateful{
    global Decimal sum;
     /* Batch class constructor */
    global batchclass(){}
    //Start method
    global Database.QueryLocator start(Database.BatchableContext BC)
    {
        String query='SELECT id, Amount from Opportunity';
         return Database.getQueryLocator(query);
        }

    //Excute method
    
global void execute(Database.BatchableContext BC, List<Opportunity> scope)
{
    //Excution logic
    //List<Opportunity> opp= new List<Opportunities>();
    AggregateResult[] gr= [SELECT SUM(Amount) optyamt FROM Opportunity];
    
    for(AggregateResult ag:gr){
        sum = (Decimal)ag.get('optyamt');
    }
    
}
      global void finish(Database.BatchableContext BC){
            // Finish logic
          system.debug(''+sum); 
       }
}
4 replies

My Requirement is I had Created a TotalAmount field on Account Object, I need to sum of the opportunity amount for all the opportunities for that account. using Batch class

This is my code and i am not getting results 

global class batchclass implements Database.Batchable<sObject>,Database.Stateful{
    global Decimal sum;
     /* Batch class constructor */
    global batchclass(){}
    //Start method
    global Database.QueryLocator start(Database.BatchableContext BC)
    {
        String query='SELECT id, Amount from Opportunity';
         return Database.getQueryLocator(query);
        }

    //Excute method
    
global void execute(Database.BatchableContext BC, List<Opportunity> scope)
{
    //Excution logic
    //List<Opportunity> opp= new List<Opportunities>();
    AggregateResult[] gr=[select id,TotalAmount__c,(select amount from Opportunities) from account where id IN:accountIds];
        system.debug(gr);
    for(AggregateResult ag:gr){
        sum = (Decimal)ag.get('optyamt');
        system.debug(''+sum);
    }
    
}
      global void finish(Database.BatchableContext BC){
            // Finish logic
          system.debug(''+sum); 
       }
}
9 replies

Hi Everyone, I have Created a field called Total Amount on Account and I need to Populate the Total Amount on Account with the sum of the opportunity amounts for all the opportunities for that account Using Batch class

I have tried this  below  code its not working 
someone please help me writing the batch class and test class for this scenerio

global class batchclass implements Database.Batchable<sObject>,Database.Stateful{
    global Decimal sum;
     /* Batch class constructor */
    global batchclass(){}
    //Start method
    global Database.QueryLocator start(Database.BatchableContext BC)
    {
        String query='SELECT id, Amount from Opportunity';
         return Database.getQueryLocator(query);
        }

    //Excute method
    
global void execute(Database.BatchableContext BC, List<Opportunity> scope)
{
    //Excution logic
    //List<Opportunity> opp= new List<Opportunities>();
    AggregateResult[] gr= [SELECT SUM(Amount) optyamt FROM Opportunity];
    
    for(AggregateResult ag:gr){
        sum = (Decimal)ag.get('optyamt');
    }
    
}
      global void finish(Database.BatchableContext BC){
            // Finish logic
          system.debug(''+sum); 
       }
}
9 replies

Hi Everyone, I have Created a field called Total Amount on Account and I need to Populate the Total Amount on Account with the sum of the opportunity amounts for all the opportunities for that account Using Batch class

I have tried this  below  code its not working 
someone please help me writing the batch class and test class for this scenerio

global class batchclass implements Database.Batchable<sObject>,Database.Stateful{
    global Decimal sum;
     /* Batch class constructor */
    global batchclass(){}
    //Start method
    global Database.QueryLocator start(Database.BatchableContext BC)
    {
        String query='SELECT id, Amount from Opportunity';
         return Database.getQueryLocator(query);
        }

    //Excute method
    
global void execute(Database.BatchableContext BC, List<Opportunity> scope)
{
    //Excution logic
    //List<Opportunity> opp= new List<Opportunities>();
    AggregateResult[] gr= [SELECT SUM(Amount) optyamt FROM Opportunity];
    
    for(AggregateResult ag:gr){
        sum = (Decimal)ag.get('optyamt');
    }
    
}
      global void finish(Database.BatchableContext BC){
            // Finish logic
          system.debug(''+sum); 
       }
}