-
SOQL Query ( Accounts and Contacts ) in Salesforce
Dear Sir / Mam,
I have one question :-Write an SOQL Query in Developer Console where I want to Display Accounts and their Corresponding Contacts ( First Name, Last Name etc ) BUT only those Accounts who have more than ONE Contact.
Thanks
RegardsRahul
# 9958495609
-
2 Replies
-
Hello Rahul,
#Apex Class
public class AccountAndContacts {
public static void displayContacts(){
List<Account> acc=[Select Id,Name from Account];
for(Account a:acc){
List<Contact> con=[Select LastName from contact where AccountId=:a.id];
for(Contact c:con){
if(con.size()>1){
System.debug('AccountName '+''+a.Name+'RelatedContacts '+''+c.LastName);
}}}}}#Anonymous Window
AccountAndContacts.displayContacts();
#Check the output in debugger log...
Hope it will help you.
Note:I have written it in simple understandable ,way you can optimize code by using nested query.
-
Hello Rahul ,
you can try this :
public class SearchCont {
public static List<Account> acct;
public static List<AggregateResult> aggRes;
public static void contSearch(){
List<String> ide=new List<String>();
aggRes =[select accountId,count(id) from contact where account.name !=null group by accountId having count(id) >1];
for (AggregateResult ar : aggRes) {
ide.add((String)ar.get('accountId'));
}
acct=[select name,(select LastName,FirstName from contacts) from account where id in :ide ];
for(account acc: acct){
system.debug('###'+acc);
for(contact con: acc.contacts){
system.debug('###'+con.LastName);
system.debug('###'+con.FirstName);}
}
}
}
Log In to reply.
Popular Salesforce Blogs
Application Event in Lightning Component in Salesforce
As we have discussed Component Events in my previous blog which is also one of the events helps to communicate between two components. Now you…
Boost Your Advisory Business with Salesforce Financial Services Tools
In today’s fast-paced financial world, advisory firms face increasing pressure to deliver personalized services, manage client relationships efficiently, and stay ahead of regulatory requirements. Salesforce…
All You Need to Know About SOQL in Salesforce
SOQL SOQL stands for Salesforce Object Query Language. Similar to SQL, but SOQL is designed especially for Salesforce data. The structure and keywords of SOQL…
Popular Salesforce Videos
Salesforce Consumer Goods Cloud Demo
Salesforce Consumer Goods Cloud is an intelligent, seamless B2B CRM solution specifically designed for the consumer goods industry. Watch this video to learn more.
Drive Adoption with In-App Guidance and our Prebuilt Salesforce Package!
With In-App Guidance generally available in the Winter ‘20 release, there’s no better time to start taking advantage of the easiest way to add informative…
Lightning Flow – Release Readiness LIVE, Summer '20 | Salesforce
Watch this amazing video & join the Product Managers to see how you can build flows and processes more efficiently with enhancements to Flow Builder,…
