How to query DateTime field in Salesforce?
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, ....
Tag: Salesforce SOQL
SOQL to find whether users have logged in to the Sandbox
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 ....
How to check SOQL performance?
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: ....
SOQL Execution Time using Developer Console in Salesforce
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 < ....
How to find Active users count, Inactive users count and whether users are assigned to the profile in Salesforce?
1. Execute the below code in Developer Console. for ( Profile objProfile : [ SELECT Name, ( SELECT Id, IsActive FROM Users ) FROM Profile ORDER BY Name ] ) ....
NOT LIKE Operator in Salesforce SOQL
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
How/Where to find a list of PushTopics created in Salesforce?
Sample SOQL: SELECT Id, Name, CreatedDate, CreatedBy.Name FROM PushTopic
What is a query locator in Salesforce?
A query locator represents a server-side cursor for a query. Typically a query locator is returned when not all the records requested in a query fit into the returned data ....
LAST_N_DAYS in Salesforce
For the number n provided, it starts with the time 00:00:00 of the current day and continues for the past n days. It includes today also. Sample SOQL: SELECT Id ....
How to Query Field Permissions for a Profile in Salesforce?
Use FieldPermissions Entity to Query Field Permissions for a Profile in Salesforce. Sample SOQL: SELECT sObjectType, Field, PermissionsRead, PermissionsEdit FROM FieldPermissions WHERE ParentId IN ( SELECT Id FROM PermissionSet WHERE ....