-
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 Effectively Manage Ideas on Salesforce Experience Cloud
The idea-creation process is a journey with many twists and turns. Ideas can be born in a flash, then bounce around for days or weeks…
What to Expect from Dreamforce 2024: Salesforce AI and Future Technologies
Dreamforce 2024 is rapidly approaching, and excitement is at an all-time high. Dreamforce, held in San Francisco, USA, is the main gathering place for tech…
Utility Bar Component in Salesforce Lightning
In this blog, I will be discussing the utility bar component that can be used to save a lot of time to perform certain tasks…
Popular Salesforce Videos
Salesforce Training Videos 1 for beginners with RealTime Projects Salesforce Demo
This video explains what a primary level person should be doing after getting any Salesforce Project. What should be steps for the same.
What is Headless Commerce? | Salesforce Commerce Cloud
Brands need to keep up with this change and require a certain level of agility and nimbleness. This is where Headless Commerce is a game…
How to Report on the Reports in Your Salesforce Org
Do you want a list of all the reports in your Salesforce org? Would you like to see a list of reports and the last…
