Sample Code:
List<AuthSession> asList = [Select Id, UsersId, Users.Name, UserType, SourceIp, SessionType, SessionSecurityLevel, ParentId,
NumSecondsValid, LoginType, LastModifiedDate, CreatedDate From AuthSession];
System.debug('asList-' + asList);
WITH SECURITY_ENFORCED clause, you can use this to enable checking for field- and object-level security permissions on SOQL SELECT queries, including subqueries and cross-object relationships.WITH SECURITY_ENFORCED Clause) and a user doesn’t have access to that field, the field will be returned and can be used by the code without any exception, but the data to that user should not have access.WITH SECURITY_ENFORCED clause is only available in Apex.WITH SECURITY_ENFORCED clause is only available in Apex. Using WITH SECURITY_ENFORCED in Apex classes or triggers with an API version earlier than 45.0 is not recommended.Example:
If the Contact Email & Phone fields permission is not accessible to the user, it will throw an exception insufficient permissions and no data will return.
SELECT Id, Name, (SELECT Email, Phone FROM Contacts) FROM Account WITH SECURITY_ENFORCED
If the Account Website filed permission is not accessible to the user, it will throw an exception insufficient permissions and no data will return.
SELECT Id, Name, Website FROM Account WITH SECURITY_ENFORCED
SOQL queries returns dateTime field values as Coordinated Universal Time (UTC) values. You can use convertTimezone() in a date function to convert dateTime fields to the user’s time zone.
Example 1:
SELECT DAY_ONLY(convertTimezone(CreatedDate)), SUM(Amount) FROM Opportunity GROUP BY DAY_ONLY(convertTimezone(CreatedDate))
Example 2:
SELECT Id, WhatId, Subject, CreatedDate From Task Where DAY_ONLY(convertTimezone(CreatedDate)) = TODAY
Note: You cannot use convertTimezone() without date function. The following query doesn’t work because there is no date function.
SELECT convertTimezone(CreatedDate) FROM Account
Check Case Owner in Apex Class.
//Check object Id in Apex
if(string.valueOf(c.OwnerId).startsWith('005')){
//Owner is User
}
if(string.valueOf(c.OwnerId).startsWith('00G')){
//Owner is Queue
}
Check Case Owner in Apex Trigger.
//In Apex Trigger
for (Case objCase : Trigger.new) {
If (objCase.OwnerID.getsobjecttype() == User.sobjecttype) {
/*Code if Owner is User*/
}
else{
/*Code if Owner is Queue*/
}
}
Check Case Owner by SOQL query.
//By Query Owner.Type Field
List<Case> caseList = [SELECT Id, CaseNumber, OwnerId, Owner.Name, Owner.Type FROM Case];
for (Case objCase : caseList){
If (objCase.Owner.Type == User.sobjecttype) {
/*Code if Owner is User*/
}
else{
/*Code if Owner is Queue*/
}
}
Check Case Owner in Process Builder.
//Check in Process Builder BEGINS([Case].OwnerId, "005") //Check Owner is User BEGINS([Case].OwnerId, "00G") //Check Owner is Queue
Here is the query to get all private reports in Salesforce.
SELECT Id, Name, Owner.Name FROM Report USING SCOPE allPrivate