Apex Code Development You need to sign in to do that
Don't have an account?
sami31 Update date on parent record with date value on second child record
HI,
Address & Call (Child obj) have a lokup relation and i would like to udpate parent address field with value in Call_Date field of the second call on that address, we use Call_Date to determine the order of the call. I tried this with a batch job and queried all calls ordered by Call_Date in start method and did the update logic in execute(). But it is updating only few address records ignoring most of them. I think its because records returned by query are divided into batches of 200 records and they are executed independently (order is not guaranteed). Due to this 2 calls (on the same address) got split into different batches and they are processed as single call in the execute(), so the address is not updated with the Call_Date of 2nd call.
How can we correct this? Is there a better solution to achieve this requirement.
Thanks.
Address & Call (Child obj) have a lokup relation and i would like to udpate parent address field with value in Call_Date field of the second call on that address, we use Call_Date to determine the order of the call. I tried this with a batch job and queried all calls ordered by Call_Date in start method and did the update logic in execute(). But it is updating only few address records ignoring most of them. I think its because records returned by query are divided into batches of 200 records and they are executed independently (order is not guaranteed). Due to this 2 calls (on the same address) got split into different batches and they are processed as single call in the execute(), so the address is not updated with the Call_Date of 2nd call.
How can we correct this? Is there a better solution to achieve this requirement.
Thanks.
you can try with your same logic in trigger and in anonymous window u can do a mass update inchild record by creating a checkbox field to true