-
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
How to leverage NetSuite and Salesforce's Analytics Capabilities hand in hand?
NetSuite and Salesforce are today's most popular cloud-based business management software solutions. While each platform has its strengths and unique features, many businesses use both…
Showcasing the Salesforce Ecosystem
Managing the Company Information with Salesforce Provides the Ultimate Support. Salesforce provides the website visitors, clients, managers, and service agents the required platform that acts…
What is Field level security in SQL? | The Ultimate Guide
What is Field Level Security in SQL? Field level security in SQL is a feature that allows administrators to control access to specific fields in…
Popular Salesforce Videos
How to Learn Salesforce Development | Salesforce learning steps for beginners | Trailhead demo
In this video, we shared the steps to learn salesforce lightning basics, salesforce apex development, CRM in online for free from scratch very quickly. Learn salesforce…
Future of Salesforce Job Market | The Shrey Sharma Show
This is the very first episode of The Shrey Sharma Show with Christopher A Hopper. They discussed Salesforce. Below is a list of questions they…
3 Easy to Use Salesforce Field Service Dashboards | AblyPro- Live Webinar
Watch AblyPro's exciting webinar video on Salesforce Field Service Reports & Dashboards. Discover how these powerful tools can drive efficiency and cut support costs for…
