-
What is the SOQL query to get all accounts related to a contact?
I need to roll-up to contacts data from related accounts. As a first step, how would the query look like to get for example the number of accounts related to a contact, or better, total AnnualRevenue of all related accounts?
-
3 Replies
-
Hi Delango.
Here is sample code:-
List<Account> acc=[Select Id,Name from Account];
for(Account a:acc){
List<Contact> con=[Select accountId, LastName from contact where AccountId=:a.id];Integer TotalAnnualRevenue = 0;
for(Contact c:con){
TotalAnnualRevenue = TotalAnnualRevenue+c.AnnualRevenue
System.debug(‘Total revenue’+ TotalAnnualRevenue);
}}
Hope this will help you.
Thanks.
- [adinserter block='9']
-
I should have clarified that I have enable the Contact to multiple Accounts relationship and what I’m trying to solve for is to roll-up data to the contact from all related accounts.
-
You do a SOQL query in LOOP – Its the best practice to fail on Governor Limits
Log In to reply.
