-
How to lock record using SOQL so it cannot be modified by other user in salesforce?
How can you lock record using SOQL so that it cannot be modified by other user in salesforce?
-
2 Replies
-
Hi saurabh,
We will need “FOR UPDATE” clause of SOQL.
Account[] accts = [SELECT Id FROM Account LIMIT 2 FOR UPDATE];
Thanks.
-
In Apex, you can use FOR UPDATE to lock sObject records while they’re being updated in order to prevent race conditions and other thread safety problems.
While an sObject record is locked, no other client or user is allowed to make updates either through code or the Salesforce user interface.For example, the following statement, in addition to querying for two accounts, also locks the accounts that are returned:
Account [] accts = [SELECT Id FROM Account LIMIT 2 FOR UPDATE];
Thanks.
Log In to reply.
Popular Salesforce Blogs
NorCal Dreamin’ 2019 Wraps Up! What Did Algoworks Witness?
A Salesforce community event led by the Salesforce community, NorCal Dreamin’ 2019 was a huge success! We had a blast while interacting with the amazing…
Can CRM Cut Costs In Expanding Your Business?
In this age of fierce competition, the one aspect which you can certainly not overlook is customer experience and customer expectation. The concept of customer retention comes…
Creating a Salesforce Platform Event With Lightning Flow
Platform events are used to integrate Salesforce business operations with external sources via the exchange of real-time event data. Platform events are safe and easy…
Popular Salesforce Videos
How to Build an Email Using Content Builder in Salesforce Marketing Cloud
Cameron Robert steps through how to build your first email in Salesforce Marketing Cloud using Content Builder by replicating an existing Salesforce email from ReallyGoodEmails.com.…
Salesforce On-Demand Administrator
Apphienz's On-demand Administrator delivers much more than the company's expectations. It is hands-on, makes the work easy, efficient and productive along with being available to…
Product Rule Vs Price Rule Salesforce CPQ
Product Rule CPQ product rules help ensure sales reps are putting together the right products and bundles every single time. You don’t have to worry…
