-
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
All You Need to Know About Salesforce Marketing Cloud Admin Settings
For each and every platform, there are many configurations that help us to set up our account as we want. With these configurations we can…
Learn Salesforce Einstein – Chapter 5 (What is DataSet?)
What is DataSet? Data set is the collection of data to train the machine to predict. Let's understand this in the real world example. Assume…
New and Comprehensive Salesforce Certification Course at JanBask Training
JanBask Training has announced the training and certification course in one of the topmost and market-leading CRM tool Salesforce. It is a well-known fact that…
Popular Salesforce Videos
Salesforce Lightning User Tips and Tricks Spring 2023
SalesPath Corporation has created a video explaining tips and tricks that every Salesforce user will find helpful in order to increase productivity. This video also…
How to Become a Salesforce Developer? No Programming Experience Needed
Salesforce Developer has once again been named one of the world's best jobs. In a list of 25 job roles, Salesforce was the only company…
Salesforce lightning customize record page: Build a Custom Record Page
Salesforce Lightning Experience comes with a slick user interface that is easy to navigate and even easier to use right from the beginning. Lightning is…
