-
What is the Limit for record retrieve in a Salesforce subquery ?
List<Account> acc=[select name (select LastName from contacts) from Account Limit 10];
Suppose i am fetching records from account and i am fetching contacts associated with each Account in a subquery then what is the limit of fetching contacts
-
1 Reply
-
This point can help you understand this:
In a SOQL query with parent-child relationship subqueries, each parent-child relationship counts as an extra query. These types of queries have a limit of three times the number for top-level queries. The row counts from these relationship queries contribute to the row counts of the overall code execution.
So, Total number of records retrieved by SOQL queries would be 50,000 altogether.
Log In to reply.
Popular Salesforce Blogs
Top Considerations in Choosing the Right Salesforce Development Partner
Salesforce is the world’s leading and one of the most powerful CRM platforms that can redefine your digital journey, foster stronger brand loyalty and engagement,…
Outsourcing Strategic CRM Support: A Case for Salesforce Service Cloud Consultant
In today's dynamic business landscape, customer relationship management (CRM) plays a pivotal role in the success of any organization. As businesses strive to build lasting…
Learn All About Salesforce Managed Services vs In-house Team
The day-to-day operations of modern businesses depend on technology and cloud-based tools. With ever-changing IT needs and business configuration tools becoming more important, one small…
Popular Salesforce Videos
Experience the Most Flexible, Easiest, and Securest Way to Integrate Salesforce and Jira
Integrate standard and custom Salesforce objects with Jira to strengthen cross-functional collaboration and deliver a top-notch customer experience. Fast-Track Your Journey to Attaining Customer Centricity…
Create a New Marker Layer in Maps | Salesforce Maps
Salesforce Maps is a location intelligence and map visualization tool that integrates with your Salesforce CRM, simplifying territory management. With Salesforce Maps you can create territories…
How to Test Your Process Builder | Salesforce
In this video, Appopedia provides helpful tips on how to test your process builder in Salesforce. She explains how to create a test user, what…
