Salesforce Fact #444 | Check record access in same SOQL

There is an object named UserRecordAccess using which we can get to know whether a particular user has specific access to one or more records. But do you know we can get that details while querying the actual object itself, no need to query the UserRecordAccess object separately.

For example, The below query on Account will return whether the current user has Edit access to the queried records or not:

SELECT Id, UserRecordAccess.HasEditAccess FROM Account.

Another cool thing is we can also get to know whether the user has access to related record as well. For example, The below query checks whether the current user has read access to the related account records while querying the contact records:

SELECT Id, Account.UserRecordAccess.HasReadAccess FROM Contact WHERE AccountId!=NULL

Comments

Post a Comment

Popular posts from this blog

Salesforce Fact #192 | Call batch apex from flow

Image
Generally apex batch jobs are scheduled to run at particular time intervals. But suppose we have a use case where we need to run the batch job on adhoc basis. We can call the batch apex from a screen flow in that case and the screen flow can be invoked from a button. So, the batch job can be executed on demand. Attached are the screenshots.
Read more

Salesforce Fact #457 | Get current user role name in flow

Image
In apex, in order to get the current user role name we need to query the UserRole object. We cannot get it directly using UserInfo object since it has only one method related to role i.e  getUserRoleId(). Using this Id returned we can get the data from UserRole object. But that is not that complex in flow. In case of flow, we can directly get the current user role name using the syntax: {!$UserRole.Name}. Attached are the screenshots.
Read more