function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

batch class to update field in parent object when child object field date__c >= today().

Here Parent object is Account,and child object is Certification__c,and the field to be updated in Parent object is Rating
Sampath KumarSampath Kumar
Hi Anji,

Good Day!

Please find the sample code below:

global class BatchUpdateAccount implements Database.Batchable<sobject>{

global string query;

global database.querylocator start(Database.BatchableContext BC){
           query = 'select Id,name from Account where Id in (select Account from Certification__c where date__c >= today)';
            return Database.getQueryLocator(query);

global void execute(Database.BatchableContext BC, List<Account> scope){
  List<Account> cons = new List<Account>();

     forAccount s : scope){
      s.fieldname='assign the value';

  update cons;    

global void finish(Database.BatchableContext BC){


To execute from developer console
BatchUpdateAccount b = new BatchUpdateAccount();

Mark this as best answer if this answers your query.

Sampath Kumar Goud