-
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
ChannelOnline To Salesforce Integration Setup [EPISODE -2]
Integration Setup In Salesforce Resellers must perform the following setup steps in Salesforce in order to exchange data Enable the correct employee for use with…
Custom Roll-up Summary on Account Object | Salesforce Developer Guide
In this blog, I would like you to share, how to display a custom roll-up summary on account, Before moving to code first create a…
Salesforce Opportunities vs. Leads in 2024
Salesforce Opportunities and Leads serve different roles in the sales process. Opportunities and Leads are the two terms most often used interchangeably by newcomers. However,…
Popular Salesforce Videos
Salesforce Trailhead - Control Access to Fields
In this video, Your Coding Buddy covers how to control access to fields in Salesforce Trailhead. He explains that this is important for keeping data…
CEPTES’s successful visit to Dreamforce’17
Thank you all to those who visited CEPTES at Dreamforce’17. It had been a great event and CEPTES would like to offer gratitude to our…
Data Import: Prepare your Data for Import | Salesforce
This short video walks you through how to clean up your import files in preparation for getting your data into Salesforce. We'll walk you through…
