If Users follow records, the entries are stored in EntitySubscription entity. SOQL: SELECT Id, ParentId, SubscriberId FROM EntitySubscription SubscriberId - ID of the User who is following the record or user. ParentId ....
Static Query and Bind Variables The first and most recommended method to prevent SOQL injection is to use static queries with bind variables. Consider the following query. Static Query: SELECT ....
If any fields or objects referenced in the SOQL SELECT query using WITH SECURITY_ENFORCED are inaccessible to the user, an exception is thrown, and no data is returned. Use the ....
0B6 is for CaseTeamMember object. Use the below SOQL to check. SELECT Id, TeamRoleId, MemberId, ParentId FROM CaseTeamMember
Salesforce stores the DateTime in GMT/UTC. Below SOQL will give the number of accounts that were created between 5 PM to 5.15 PM EST. Since EST is +5 from GMT, ....
SOQL on the Login History object/entity can be used to find whether users have logged in to the Sandbox. Sample SOQL: SELECT Id, LoginTime, UserId FROM LoginHistory WHERE DAY_ONLY( LoginTime ....
1. Go to Developer Console. 2. Navigate to Debug --> View Log Panels… 3. Select Execution Stack. Trigger Execution Stack Developer console Salesforce Visualforce Execution Stack Developer console Salesforce Note: ....
Option 1: 1. Go to Developer Console. 2. Navigate to Debug --> View Log Panels… 3. Select Execution Stack. Sample Code with SOQL to execute in Anonymous Window: List < ....
1. Execute the below code in Developer Console. for ( Profile objProfile : [ SELECT Name, ( SELECT Id, IsActive FROM Users ) FROM Profile ORDER BY Name ] ) ....
We can use both NOT and LIKE operators in Salesforce SOQLs. Please check the following SOQL for reference. Sample SOQL: SELECT Name FROM Account WHERE NOT Name LIKE 'Test%' https://youtu.be/2CW4Xd8U8aI