-
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
Introduction of Call Center Computer Telephony Integration | Salesforce Guide
In this blog, we are going to discuss call center integration. Computer Telephony Integration with Salesforce. CTI, or Computer Telephony Integration, is the practice of…
Why Salesforce Lightning is the Key to Unlocking Your Sales Potential
Salesforce is the world's leading customer relationship management (CRM) platform, enabling businesses to manage their customer interactions, streamline their operations, and increase their revenue. With…
Synchronous and Asynchronous calls using Apex in Salesforce
Synchronous And Asynchronous Apex Synchronous: Don’t forget to check out: Asynchronous Apex In a Synchronous name, the thread will wait until it completes its obligations…
Popular Salesforce Videos
How To Use Dynamic Prefill Link of Formstack | Learn Salesforce Series by Algoworks
Learn how to use ‘Dynamic Prefill Link’ of Formstack in 4 easy steps! 1. Introduction Short introduction of FormStack and its uses. 2. The need…
Salesforce CRM Services offered by Melonleaf Consulting
Melonleaf Consulting offers customized and configured Salesforce CRM Solutions and Services that can revolutionize your business. Experience the power of top-notch and highly effective Salesforce…
Automate Your App With and Without Code | Salesforce Developer Tutorial
In this video, you will learn how you can automate your business process with and without code. This video teaches you how to use a…
