-
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.
- [adinserter block='9']
-
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.
