-
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
Salesforce Data Cloud vs. Traditional Data Warehouses: Which wins for AI?
The rise of Artificial Intelligence (AI) has forced a major shift in corporate data strategy. Companies no longer just store data. They now need data…
Get Started With Triggers in Salesforce | The Complete Guide
Triggers are the automated actions that are performed whenever DML operations are performed on the object. Before Trigger: These triggers are fired before the new…
How Salesforce Sales Cloud changed the Sales Process at the EV Company?
The effectiveness of a company's sales operations can make or break it in the fiercely competitive Electric Vehicle (EV) market. Because of their complicated goods…
Popular Salesforce Videos
Automate Simple Business Processes with Process Builder | Salesforce Trailhead
In this video, we working on the Trailhead challenge Lightning Flow unit Automate Simple Business Processes with Process Builder where a lot of trailblazers face…
Salesforce Developer Tools and Productivity
Kevin Poorman shows how you can use Salesforce Developer Tools and how you can unlock developer productivity. Watch this video to learn more.
Salesforce QA Interview Guidance Program
Do you want to learn what it takes to clear a Salesforce QA interview? In this video, Bava Dharani Ganesan gives a detailed explanation of…
