function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Vijay sidaraddiVijay sidaraddi 

I have two object A and object B

Hi 

I have two object A and object B where object b is having  three records in it  i have to do some perform action on object A when object B is to have 4 records in it. how to acheive it , logic 

Thanks
Vijay 
amit singh 2096amit singh 2096
Hi Vijay,

In your after insert trigger use the database.countQuery method to get the count of the dynamic SOQL, and check the no of record in Obect B.
 like below 
integer count= database.countQuery('select count() from B');

if(count == 4){
// update records on Obj A

}

Regards,
Amit
 
ManojjenaManojjena
Hi Vijay ,
Here I have one question ,Is there any relationship between Obj A & Obj B .Or just you need to to check over all count of object B record ?
You have to write a trigger in Object A .Inside tthe trigger you can do a aggregate query to get the countof the record in Object B .
Integer recCountOfObjA=[SELECT count() FROM B];
However if you want the both object have relationship then logic will very if you want like each record needs to implement same logic .
Let us know so that we can help !!
Thanks 
Manoj