-
I want to count related Contact in a Account.How can i do this in salesforce Apex Code?
I want to count related Contact in a Account.How can i do this in Apex Code?
-
2 Replies
-
Hi Suraj,
public class AccountProcessor {
static public Integer count;
@future public static void countContacts(Set<Id> AcctId ){
List<Account> Acclist=[select name,AccountNumber from Account where Id in:AcctId];
if(Acclist.size()>0){
for(Account A:Acclist){
count=0;
count=[select count() from Contact where AccountId=:A.Id];
A.Number_of_Contacts__c=count;//[select count() from Contact where AccountId=:A.Id];
update(A);
}
}where Number_of_Contacts__c is the custom Field on Account which store the Number of Related Contact in Account.
Hope this will Help You
- [adinserter block='9']
-
Hi Suraj,
A much-optimized code would be -
Public static Map<Id,Integer> countRelatedContact( Set<Id> accId){
Map<Id,Integer> relatedCountMap = new Map<Id,Integer>();
if(!accId.isEmpty){for(Account acc : [select Id, name,(Select Id, Name from Contacts) from Account where Id in:accId];){
relatedCountMap.put(acc.Id,acc.Contacts.size());
}return relatedCountMap;
}This will return a Map of Account Id and # of related Contacts to that Account record. Hope this helps you as per your scenario.
Thanks,
Subhendu
Log In to reply.
Popular Salesforce Blogs
Creating a Culture of Innovation in Your Organization With IdeasPro | Salesforce Community Cloud
“We are what we repeatedly do.” – Aristotle Culture can be defined as a consistent pattern in behaviour in an organization. An innovation culture works…
Preventing Duplicate Records in Your Salesforce Org for Improved Customer Relationships
Clean and accurate data is the backbone of every business. This means data quality is an important attribute of success for any organization. And, duplicate…
Passing the Salesforce AI Specialist Certification with Dumpsforsure – Your Complete Success Guide
Introduction : The Salesforce AI Specialist certification has quickly become one of the most valuable credentials for professionals working in artificial intelligence and CRM technology.…
Popular Salesforce Videos
ChartJs Implementation In Salesforce
This was my very first lightning web component I had made on my own. Thought of sharing it 🙂 This component basically shows the no.…
Salesforce Service Cloud Implementation
Salesforce Service Cloud offers a long list of powerful tools to help you realize the potential of your service team. With the endless opportunities for…
Salesforce Multi-factor Authentication/Two-factor Authentication End User Training Video
Watch this video to learn all about Salesforce Multi-factor Authentication/Two-factor Authentication. This is a training video. Watch and learn.
