-
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
Learn Salesforce Einstein – Chapter 7 (What is Training in Machine Learning?)
Training a process where we create a model using our datasets. Every prediction query goes to Model, not to the dataset. Let's assume we have…
Salesforce Marketing Cloud Growth vs. Advanced Edition: A Comprehensive Comparison
In today’s fast-evolving digital environment, customer experiences are pivotal to business success. Salesforce Marketing Cloud, a leading platform for customer engagement, offers two prominent editions:…
The Underlying Impact of CRM Disintegration: How Enterprises Lose Revenue Without a Centralized Salesforce Ecosystem
Modern enterprises depend on CRM systems to drive revenue, manage customer relationships, and enable data-driven decisions. Yet, many organizations operate with disconnected tools spread across…
Popular Salesforce Videos
How To: Build A Salesforce Career with This Tool!
Timecodes 0:00 - Intro & Overview 0:57 - Talent Stacker 3:00 - Career Progression 10:08 - Flow is the Future 13:36 - Learn More/Outro If…
Is The Salesforce Job Market Saturated? | The Facts
You may have heard that the Salesforce job market is saturated, however there is no evidence to indicate this, in fact it’s the exact opposite!…
