-
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 the Grant Management System in Salesforce? | All You Need to Know
Grant Management in Salesforce is a component of the Nonprofit Success Package (NPSP). In this package, Salesforce will award her 10 free licenses to some…
Salesforce Financial Services Cloud – Why is it Worth the Hype?
Financial services corporations need to act faster on their customers’ needs by offering quick & robust solutions. And to help with that, the #1 CRM,…
Insert sObject record using Javascript in Salesforce Visualforce Page
How to insert record in Salesforce by using Javascript In this blog, I will let you know how to insert record in Salesforce by using…
Popular Salesforce Videos
A day at Dreamforce Event!
Time to share with you all the Algoworks Experience at Dreamforce 2019. The fun at Dreamforce was unparalleled, come relish the Dreamforce week with us!…
Web to Case Functionality in Salesforce | All You Need to Know
This video discusses the functionality of Web to Case in Salesforce, which allows website users to submit inquiries or information that can be converted into…
Respecting Data Protection Laws on Salesforce
This video tells us all about data protection regulations and how to implement them on the Salesforce platform when designing custom solutions: - Introduction to…
