-
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
Why Salesforce Is good For Business - Top Reasons
Salesforce is an application advancement stage, fundamentally famous for its Customer Relationship Management (CRM) programming for different administrations like advertising and client assistance. The CRM…
What To Do When Salesforce Apex Heap Size Increases?
Welcome to Salesforce! You've just encountered your first governor limit . The 'Apex heap size too large' error occurs when too much data is being…
Why Use Second-Generation Packages in Salesforce?
Do you know about Second-Generation packages? Max Shkrob, Salesforce Developer at Twistellar, gathered all the features and the main differences between 1GP and 2GP. Happy…
Popular Salesforce Videos
Run UI Tests with UTAM | Salesforce Developer Tutorial
Testing apps is critical to ensure quality and there are different types of tests such as unit tests, integrations tests or end-to-end tests just to…
What it Means to be a Salesforce Developer
In this video, Salesforce with Polina describes what it means to be a Salesforce Developer. She goes on to describe the different types of Salesforce…
Salesforce Administrator and App Builder Training
S2 Labs Salesforce admin certification training Tutorials for FREE. In this course, you will learn about the Salesforce Platform Basics, customizing Salesforce with Lightning Experience…
