-
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
Mastering Continuous Integration Top Tools and Techniques for DevOps
In today's digital environment, such innovation has to be very fast and efficient to outcompete others. Continuous Integration has become the bedrock of DevOps practices…
Create Dynamic Actions in Salesforce - Step-by-step Guide
Dynamic Actions are the actions that display the actions based on the criteria that you have provided. It means the actions will appear or disappear…
Here’s what makes Field Service Lightning the fastest growing product of Salesforce
In the era of Digital Transformation, Customer Experience (CX) is the new battleground, and delivering superior CX has never been more important. In fact, according to…
Popular Salesforce Videos
ChartJs Implementation In Salesforce
This was my very first lightning web component I had made on my own. Thought of sharing it 🙂 This component basically shows the no.…
3 Tips on How To Deliver a Successful Product Launch | Salesforce on Salesforce
Salesforce defines a product launch as announcing a new offering to the public. Launches are an opportunity to tell a compelling story about your product,…
Sandbox Design Strategies for Enterprise Implementations
It is inevitable to avoid Sandboxes in most enterprise implementations. As different teams work on different processes like testing, development, pre-release, and final rollout, it…
