Tag: Salesforce SOQL

 LoginHistory entity can be used to find whether users are using Data Loader. The Application column/field in the LoginHistory entity will be one of the following when logged in from ....

Sample SOQL:SELECT Name, Format, LastRunDate, LastViewedDate, LastModifiedDate, CreatedDate FROM Report  Output: SOQL to find reports that last ran last year:SELECT Name, Format, LastRunDate, LastViewedDate, LastModifiedDate, CreatedDate FROM Report WHERE LastRunDate = ....

Sample SOQL:SELECT Name, DeveloperName FROM Report WHERE Id IN ( SELECT CustomReportId FROM DashboardComponent WHERE DashboardId = '01Z5f000000VAB9EAO' ) Output:

1. Open the Profile. 2. Right Click on the browser and select "Inspect". 3. Use Select An Element to inspect the page. 4. Select the Permission Name. 5. You will ....

To create, edit, or view process builders, user should have "Manage Flow" and "View All Data" permissions.Following SOQL will fetch the Profiles which has "Manage Flow" and "View All Data" ....

Following SOQL will fetch the Profiles which has "Manage Flow" and "View All Data" permissions.SOQL: SELECT Id, Name FROM Profile WHERE PermissionsViewAllData = true AND PermissionsManageInteraction = truePermissionsViewAllData is the ....

Sample SOQL to get Permission Set Names assigned to the Permission Set Group: SELECT PermissionSetGroup.DeveloperName, PermissionSet.Name FROM PermissionSetGroupComponent Sample SOQL to get Users assigned to the Permission Set Group: SELECT ....

Sample Event with Event Attendees:Sample SOQL:SELECT Id, Relation.Name, Status FROM EventRelation WHERE EventId = '00U5f000001MxwFEAS'

Sample SOQL:SELECT Id, OldValue, NewValue, Field FROM ContactHistory WHERE Field = 'Account' AND ContactId = '0035f000002a3PlAAI' Output: