How to query String format using SOQL?
Sample SOQL: SELECT BillingPostalCode FROM Account WHERE BillingPostalCode != NULL AND BillingPostalCode LIKE '___-__' Output:
Author: Magulan Duraipandian
How to find how many profile have Edit Tasks permission?
Sample SOQL: SELECT Name, PermissionsEditTask FROM Profile WHERE PermissionsEditTask = true Output:
Query User Permission from Profile in Salesforce
Sample Query: SELECT Name, PermissionsViewAllUsers, PermissionsViewEventLogFiles FROM Profile
How to get all Email Fields in Salesforce?
Sample Code: Set < String > listsObjs = new Set < String > {'Account', 'Lead'}; Map<String, Schema.SObjectType > globalDescription = Schema.getGlobalDescribe(); for ( String obj : listsObjs ) { Schema.sObjectType objType = globalDescription.get( obj ); Schema.DescribeSObjectResult r1 = objType.getDescribe(); Map<String , Schema.SObjectField > mapFieldList = r1.fields.getMap(); for ( Schema.SObjectField field : mapFieldList.values() ) { Schema.DescribeFieldResult fieldResult = field.getDescribe(); String fieldLabel = fieldResult.getLabel().toLowerCase(); Schema.DisplayType fielddataType = fieldResult.getType(); if ( fielddataType == Schema.DisplayType.Email ) { System.debug( objType + '.' + fieldResult.getName() ); } else if ( fieldLabel.contains( 'email' ) && ! fieldResult.isCalculated() ) { System.debug ( objType + '.' + fieldResult.getName() ); } ....
How to get all First Name and Last Name Fields in Salesforce?
Sample Code: Set < String > listsObjs = new Set < String > {'Account', 'Lead'}; Map<String, Schema.SObjectType > globalDescription = Schema.getGlobalDescribe(); for ( String obj : listsObjs ) { Schema.sObjectType objType = globalDescription.get( obj ); Schema.DescribeSObjectResult r1 = objType.getDescribe(); Map<String , Schema.SObjectField > mapFieldList = r1.fields.getMap(); for ( Schema.SObjectField field : mapFieldList.values() ) { Schema.DescribeFieldResult fieldResult = field.getDescribe(); String fieldLabel = fieldResult.getLabel().toLowerCase(); Schema.DisplayType fielddataType = fieldResult.getType(); if ( ( fieldLabel.contains( 'first name' ) || fieldLabel.contains( 'last name' ) || fieldLabel.contains( 'firstname' ) || fieldLabel.contains( 'lastname' ) ) && ! fieldResult.isCalculated() ) { System.debug ( objType + '.' + fieldResult.getName() ); } } } In the ....
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 ] ) ....
Simple Custom Lightning Template
Sample Code: Component: <aura:component implements="lightning:recordHomeTemplate"> <aura:attribute name = "left" type = "Aura.Component[]" /> <aura:attribute name = "middle" type = "Aura.Component[]" /> <aura:attribute name = "right" type = "Aura.Component[]" /> <div> <lightning:layout > <lightning:layoutItem size = "2"> {!v.left} </lightning:layoutItem> <lightning:layoutItem size = "5"> {!v.middle} </lightning:layoutItem> <lightning:layoutItem size = "5"> {!v.right} </lightning:layoutItem> ....
How to adjust left and side bar width in Salesforce Service Cloud Console?
1. Go to the object page layout. 2. Click Edit button. 3. Go to Custom Console Components. 4. Adjust the width. Output:
How to find Password Expiration Date for users in Salesforce
Password Expiration Date is available on the standard Users report type to find the Password Expiration Date for users in Salesforce. So, using the standard Users report type, we can ....
How to find profile permissions for objects in Salesforce?
Sample SOQL: SELECT Parent.Profile.Name, sObjectType, PermissionsCreate, PermissionsRead, PermissionsEdit, PermissionsDelete, PermissionsModifyAllRecords, PermissionsViewAllRecords FROM ObjectPermissions WHERE ParentId IN ( SELECT Id FROM permissionset WHERE PermissionSet.Profile.Name IN ( 'System Administrator', 'Read Only' ) ) ORDER BY sObjectType, Parent.Profile.Name The above SOQL will give profile name, object name, create access, read access, edit access, delete access, modify all access and view ....