3.6K
How do Count the number of child records using SOQL?
Its possible to collect the child records count from parent object using following SOQL:
SELECT Id, Name, (SELECT id FROM Contacts) FROM Account limit 10
Map<Id, Integer> ContactCountMap = new Map<Id, Integer>();
List<Account> lstAccount= [SELECT Id, Name, (SELECT id FROM Contacts) FROM Account limit 10];
for (Account A : lstAccount) {
ContactCountMap.put(A.Id, A.Contacts.size());
}
system.debug(‘ContactCountMap:::::’ContactCountMap);