-
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
Top 5 Leading Salesforce Marketing Product
Not getting the desired results from your marketing campaigns? Improving your marketing strategy has become critical in today’s competitive world where businesses aim to connect…
Choosing the Right Cloud Consulting Company: A Decision-Making Guide
Do you wish to leverage cloud technologies or want to migrate your business to the cloud? If so, you are making a great choice! Cloud…
What is Marketing Cloud? Know the Features and Benefits for Businesses
The era of digitization is surging with the evolution and advancements of technologies. Gone are the days when businesses used to rely only on a…
Popular Salesforce Videos
Getting Started With The Ant Migration Tool in Salesforce
Ant Migration Tool In Salesforce. In this video, the following points will be covered - 1. Introduction Get a brief introduction about the Ant Migration…
Tableau CRM for Emergency Response Management | Salesforce
When disaster strikes, public and private health organizations, as well as government agencies, need to respond quickly and efficiently. Tableau CRM for Emergency Response Management…
MuleSoft Integration: Google Ads Lead Form to Salesforce - Learn Salesforce Series by Algoworks
MuleSoft integration: Google Ads lead form to Salesforce. In this video, learn how MuleSoft can be used to integrate Salesforce with Google Ads lead form.…