Tag: Salesforce SOQL

Sample SOQL:SELECT Id, Name, ( SELECT Id, Subject, Status FROM ActivityHistories ) FROM Account WHERE Id = '0018c000026ZmPmAAK'  Output: 

Sample Contact Record:  SOQL:SELECT Id, AccountId, Account.Name FROM AccountContactRelation WHERE ContactId IN (SELECT Id FROM Contact WHERE Email = '[email protected]' )  Output: 

Sample SOQL:SELECT Id, Name FROM User WHERE UserPermissionsSupportUser = true  Output:  

 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" ....