-
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
Salesforce vs ERP: Understanding the Key Differences
It's very common to encounter misconceptions about Salesforce being just another ERP system. However, understanding the distinct functionalities and capabilities of Salesforce compared to traditional…
Salesforce Boosts its Marketing Cloud with Partnership with AI and Google
The Salesforce CRM is extremely customizable by design. A Salesforce development company provides CRM solutions for different customer requirements across a lot of industry domains.…
How to Become a Successful Salesforce Developer?
In today's technology-driven world, Salesforce has emerged as a powerful force in the business ecosystem. With its robust customer relationship management (CRM) platform and extensive…
Popular Salesforce Videos
Record Triggered Flows with Real Time Scenarios | Salesforce Tutorial
In this video, you will understand 1. What is Record triggered flow? 2. How and when to use Record triggered flows? 3. Real-time scenarios 4.…
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 use Salesforce Data to drive producivity and greater data capture
How do you encourage and drive better quality data entry into Salesforce by Salespeople? How do you use that data to drive productivity and proactive…
