-
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
What Is Salesforce Workbench - The Complete Developer Guide
What is Salesforce Workbench? Salesforce Workbench is a tool that brings together a number of advanced features and capabilities into one place. A lot of…
Salesforce Engage | Propel Customer Engagement with Relevancy
Marketing without customer engagement is nothing more than an on-air commercial that nobody wants to see. Every day the competition is intensifying, and keeping customers…
Einstein Prediction Builder: Next Steps to Build an Automated Flow
This article is prepared by our Salesforce Administrator Dzmitry Pimenau. Automation of Actions based on Predictions In the first part of the article we described the…
Popular Salesforce Videos
How To Dominate Peak Shopping Seasons with Salesforce Commerce Cloud?
Peak shopping seasons can make or break a business. In our latest webinar, we break down the power of Salesforce Commerce Cloud and how it…
Salesforce Validation Rules - Keep your Data Clean
Watch this short video for just over 2 minutes and learn how to keep your Salesforce data clean? The answer is simple: Use field validation…
Break up Salesforce Record Detail into Tabs | Salesforce Lightning Page Layouts
In this video, Signiforce briefs about how to create an Action with a subset of fields from your object and then add this action to…
