-
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
Ways to Optimize Your Salesforce Org in Business
Observing end-client appropriation and wiping out specialized obligations are the two foundations for developing a hearty CRM-compelling Salesforce organization, yet in the event that you…
Never Miss Another Deal With Salesforce Opportunity Management
Selling is all about seizing opportunities and closing deals quickly and efficiently. This means it’s time to look at what hurdles and challenges actually stop…
Salesforce With Selenium
This is my First post for Salesforce with Selenium. In this post, we will understand why we use selenium in salesforce and how we are…
Popular Salesforce Videos
Why There Are So Many Acquisitions in The Salesforce Ecosystem?
Global technology acquisition deals amounted to $634.1 billion in 2020, an increase of 91.8% year-on-year. An acquisition is when one company purchases most or all…
Salesforce Connections 2018 Keynote - Ch. 1: Corporate Positioning
Salesforce Connections 2018 Keynote – Ch. 1: Corporate Positioning Salesforce Connections 2018 Keynote – Ch. 2: Ticketmaster Is A Trailblazer Salesforce Connections 2018 Keynote –…
Rise & Shine with The Salesforce Women's Entrepreneur Group
The Salesforce Women’s Entrepreneur Group invites you to our first quarterly event of the year, Rise & Shine - Celebrating Women’s History Month. We are…