-
What are Cursors in Salesforce?
What exactly do we mean if we say "A user can have up to 50 query cursors open at a time".
-
3 Replies
-
Hi Manpreet
a cursor is a reference to the the result set for a soql query.
Select Id, name, (select Id, name from contacts) from account
Will account for 2 open cursors.
The way out was to simplify the soql queries and break what we were trying to achieve in one batch apex class over 2 classes.
Hope it may help
-
Cursors, as I understand, are the equivalent of query result sets. A similar concept exists in SQL if you're familiar with it.
So I'd say a cursor is a reference to the result set for a soql query.
I had a support case with Salesforce a while ago about cursors exceeded in a batch apex query. Apparently even inner queries will account for their own cursor set
So
Select Id, name, (select Id, name from contacts) from accountWill account for 2 open cursors.
The way out was to simplify the SOQL queries and break what we were trying to achieve in one batch apex class over 2 classes.
-
Cursors : It is equivalent to the Soql query result set. In cursor a user can have up to 10 query cursors open at a time. If 10 QueryLocator cursors are open in the application and the same user, attempts to open a new one, then the oldest of the 10 cursors is released. If the client application attempts to open the released query cursor, an error results.
Log In to reply.
Popular Salesforce Blogs
Why Is Salesforce Training Worth Your Time and Money?
Salesforce is one of the greatest customer relationship management platforms. The majority of the Salesforce expert Salesforce training can prove you lucrative. You can take…
Implement Salesforce In Your Business
Salesforce is an amazing platform with boundless potential outcomes. As a Salesforce implementation project manager, you will own the implementation process and guide the project…
How to Use Salesforce to Improve Your Automobile Business?
The automobile industry is complex and ever-changing. In order to stay ahead of the competition, automobile businesses need to use the latest technology to improve…
Popular Salesforce Videos
Florida DataTribe EA Virtual Salesforce Saturdays
Learn to teach so you can learn by teaching. The how why and when of the Florida DataTribe and their Einstein Virtual Salesforce Saturdays. Enjoy…
How to Edit List View Filters in Accounts and Contacts Tabs | Salesforce
Watch this video to learn How to Edit List View Filters in ‘Accounts’ and ‘Contacts’ Tabs. If you find anything confusing or have any questions,…
Introduction To Salesforce | Salesforce Training Videos For Beginners
Are you confused to choose the best edition tool? For CRM and Branding then here is the information for you! Salesforce is one of the…
