-
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
Decoding Ineffectiveness: Recognizing Red Flags in Your Salesforce Partner Relationship
When it comes to tech partnerships, teaming up with Salesforce partner is a big deal for customer relations. But let's be real - not every…
Streamlining Financial Advisory Services with Salesforce
Introduction Regarding financial advisory services, efficiency is pitted against personalization in a landscape governed heavily by regulation. The drivers have converged and it is a…
How Dean Infotech's Automated CSAT Surveys Enable Business Growth?
Ever noticed how some companies consistently deliver outstanding customer experiences? From the customer’s side, it seems effortless — but behind the scenes, maintaining that across…
Popular Salesforce Videos
FlexDeploy for Salesforce
FlexDeploy can improve your enterprise software development, operations, and release processes using out-of-the-box support for Salesforce. See how FlexDeploy supports org-based development, source-driven development, or…
The Secret Truth of Automating Processes in Salesforce
Just because you CAN AUTOMATE something in Salesforce, DOESN'T MEAN YOU SHOULD! Join for an insightful and entertaining discussion where you will learn: - How…
How to Enable the New Pardot Email Builder | Salesforce Pardot
Learn how to set up the new Email Builder for Pardot and set up Salesforce CMS for email content storage. Watch this video and do…
