-
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
How to Prepare for Salesforce Data Migration in 2024?
In Customer Relationship Management (CRM), Salesforce is a colossus, offering unparalleled capabilities for managing customer interactions, sales, and marketing. However, the transition to Salesforce, particularly…
7 Salesforce Podcasts to Listen To in 2022-2023
If you work in Sales or Marketing, there’s no way you haven’t at least heard of the customer relationship management tool Salesforce. This software allows…
Top 10 Job Profiles for Salesforce Certified Professionals
Salesforce is one of the most used and popular CRM software that is best known to manage customer information. It is being used across a…
Popular Salesforce Videos
Salesforce Surveys | Salesforce Tutorial Video
In this short video, we will demonstrate how to enable surveys to use for employees. You can also enable surveys for customers or external participants…
Salesforce CRM Full Training Tutorial For Beginners
In this video, Nick Boardman explains how to use the key features inside Salesforce CRM. He explains various dashboard options, setting up campaigns etc.
What is Record Types in Salesforce?
Record Types is where you have multiple page layouts to a specific profile. Watch this video to learn all about it.
