Skip to Content

TheBlogReaders.com

Salesforce.com, PHP, MySQL, Javascript, Ajax, Htacces

How do Count the number of child records using SOQL

Be First!
by December 23, 2014 APEX, SALESFORCE, SOQL

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);

(1090)

Previous
Next

Leave a Reply