-
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.
- [adinserter block='9']
-
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
Why Your CRM Isn't Delivering ROI: 7 Salesforce Consulting Solutions That Fix It
Enterprise investments in customer relationship management (CRM) software represent a substantial portion of modern technology budgets. Organizations clear capital paths for these platforms with the…
Salesforce Quickstart: How to Implement Salesforce Quickly and Maximize your Productivity
Salesforce is a leading Customer Relationship Management (CRM) software used globally by businesses of all sizes in terms of market share. However, Salesforce implementation can be overwhelming,…
How CRM Benefits Small Businesses: 9 Key Advantages
Small businesses often grow through personal relationships, repeat customers, referrals, and consistent follow-ups. But as the number of customers increases, managing every interaction through spreadsheets,…
Popular Salesforce Videos
Create Walkthroughs in Salesforce Lightning Experience
This video shows you how to create a walkthrough with the In-App Guidance Builder. Then you can create hands-on guided training experiences for in-app onboarding,…
Salesforce Admin Freelancing - $32,000 in 1 Month - Learn How You Can Do It
I made $32,000 last month, working only 20 hours per week. I want to show you how to do the exact same thing! Pricing increases…
How to Configure SAML Single Sign-On with Salesforce as the Identity Provider
Configure single sign-on with a Salesforce org as the identity provider for an external Heroku app acting as the service provider, using SAML. Watch this…
