Apex Code Snippets
Get Count Of Records By A Particular Attribute/Field
SELECT Status, COUNT(id) numRecs FROM Case GROUP BY Status;
Get A List Of All Objects
@AuraEnabled(cacheable=true)
public static List<ObjectWrapper> getObjectNames() {
List<ObjectWrapper> listOfObjects = new List<ObjectWrapper>(); //using an inner class called ObjectWrapper to have the fields i'm interested in
Map <String, Schema.SObjectType> schemaMap = Schema.getGlobalDescribe();
List<String> entities = new List<String>(schemaMap.keySet());
entities.sort();
for(String key: entities) {
System.debug(' ===== ' + key + ' : ' + schemaMap.get(key) + ' | Label: ' + schemaMap.get(key).getDescribe().getLabel());
ObjectWrapper objWrap = new ObjectWrapper();
objWrap.objectLabel = schemaMap.get(key).getDescribe().getLabel();
objWrap.objectAPIName = schemaMap.get(key).getDescribe().getName();
// don't return some standard ones like history, tag, share table, etc.
if(!objWrap.objectAPIName.containsignorecase('history') && !objWrap.objectAPIName.containsignorecase('tag')&&
!objWrap.objectAPIName.containsignorecase('share') && !objWrap.objectAPIName.containsignorecase('feed') &&
!objWrap.objectAPIName.containsIgnoreCase('changeevent')){
listOfObjects.add(objWrap);
}
}
return listOfObjects;
}
Get Field Names For An Object
@AuraEnabled(cacheable=true)
public static List<FieldWrapper> getFieldsForObject(String objName) {
List<FieldWrapper> listOfFields = new List<FieldWrapper>(); //using an inner class to store the fields i'm interested in.
// Get the object type of the SObject.
Schema.sObjectType objType = Schema.getGlobalDescribe().get(objName);
// Describe the SObject using its object type.
Schema.DescribeSObjectResult objDescribe = objType.getDescribe();
// Get a map of fields for the SObject
Map <String, Schema.SObjectField> fieldMap = objDescribe.fields.getMap();
List<String> fieldNames = new List<String>(fieldMap.keySet());
fieldNames.sort();
for(String key: fieldNames) {
/*system.debug(' === get object details === ' + fieldMap.get(key).getDescribe().getLabel() +
' | isAccessible ---> ' + fieldMap.get(key).getDescribe().isAccessible() +
' | isCreateable ---> ' + fieldMap.get(key).getDescribe().isCreateable() +
' | isDefaultedOnCreate ---> ' + fieldMap.get(key).getDescribe().isDefaultedOnCreate() +
' | isPermissionable ---> ' + fieldMap.get(key).getDescribe().isPermissionable() +
' | isUpdateable --->' + fieldMap.get(key).getDescribe().isUpdateable() +
' | isNillable ---> ' + fieldMap.get(key).getDescribe().isNillable()
);*/
FieldWrapper fwrap = new FieldWrapper();
Schema.DescribeFieldResult fr = fieldMap.get(key).getDescribe();
fwrap.fieldLabel = fr.getLabel();
fwrap.fieldAPIName = fr.getName();
fwrap.fieldType = fr.getType().name();
fwrap.fieldLength = String.valueOf(fr.getLength());
fwrap.isExternalID = fr.isExternalID();
if(fwrap.fieldAPIName.endsWithIgnoreCase('__c')) {
fwrap.fieldIconName='standard:custom';
fwrap.fieldIconTitle='Custom Field';
}
else {
fwrap.fieldIconName='standard:default';
fwrap.fieldIconTitle='Standard Field';
}
listOfFields.add(fwrap);
}
return listOfFields;
}
Get A List Of All Outbound Change Sets
PageReference pr=new PageReference('/changemgmt/listOutboundChangeSet.apexp');
Blob output=pr.getContent();
System.debug('### Content = \n' + output.toString());
Get Ip Address
/* code to get the IP address for the user submitting a webform.*/
public static String GetUserIPAddress() {
string ReturnValue = '';
// True-Client-IP has the value when the request is coming via the caching integration.
ReturnValue = ApexPages.currentPage().getHeaders().get('True-Client-IP');
// X-Salesforce-SIP has the value when no caching integration or via secure URL.
if (ReturnValue == '' || ReturnValue == null) {
ReturnValue = ApexPages.currentPage().getHeaders().get('X-Salesforce-SIP');
} // get IP address when no caching (sandbox, dev, secure urls)
if (ReturnValue == '' || ReturnValue == null) {
ReturnValue = ApexPages.currentPage().getHeaders().get('X-Forwarded-For');
} // get IP address from standard header if proxy in use
return ReturnValue;
} // GetUserIPAddress
Get Data From Custom Metadata Types
String queueExt = '69381';
CTI_Case_Queue__mdt[] queueMapping = [SELECT MasterLabel, Label, DeveloperName, Queue_Extension__c, Queue_Name__c
FROM CTI_Case_Queue__mdt
WHERE Queue_Extension__c = :queueExt];
System.debug('==== queueExt: ' + queueExt);
System.debug('==== num of records: ' + queueMapping.size());
for(CTI_Case_Queue__mdt q : queueMapping)
{
System.debug('==== MasterLabel: ' + q.MasterLabel);
System.debug('==== Label: ' + q.Label);
System.debug('==== DeveloperName: ' + q.DeveloperName);
System.debug('==== Queue_Extension__c: ' + q.Queue_Extension__c);
System.debug('==== Queue_Name__c: ' + q.Queue_Name__c);
}
Publish A Document Into A Library
if(!documentIdsList.isEmpty()) { // add the document to the unpublished library first.
Id internalLibraryId = Utils.getLibraryId('Sample Library');
ContentWorkspace internalLib = [Select Id FROM ContentWorkspace WHERE NAME = 'Sample Library'];
if (internalLibraryId != null) {
// link the file to the unpublished library by default. When the order gets published the file will be
// shared with t he published library. We can remove the share with the public library but we can't remove it from
// the unpublished library since that was the first library the file was shared with. By defualt the first library
// the document gets linked to is the owner of that library, so link it to the unpublished library first.
for(Id docId: documentIdsList) {
//ContentWorkspaceDoc cwd = new ContentWorkspaceDoc(ContentDocumentId = docId, ContentWorkspaceId = internalLibraryId);
ContentWorkspaceDoc cwd = new ContentWorkspaceDoc(ContentDocumentId = docId, ContentWorkspaceId = internalLib.Id);
addToLibraryList.add(cwd);
}
}
if(!addToLibraryList.isEmpty()) {
insert addToLibraryList;
}
}
Get A List Of All Related Objects From A Parent Object
Set<String> results = new Set<String>();
for( ChildRelationship r: Case.SObjectType.getDescribe().getChildRelationships()) {
results.add(string.valueOf(r.getChildSObject()));
}
system.debug(string.join(new List<String>(results), ', '));
Get Fields On Page Layout Using Apex Metadata Api
List<Metadata.Metadata> accountLayout = Metadata.Operations.retrieve(Metadata.MetadataType.Layout, new List<String> {'Account-Account Layout'});
Map<String, List<String>> layoutFieldsMap = new Map<String, List<String>>();
List<String> fields = new List<String>();
System.debug('accountLayouts: ' + accountLayout);
Metadata.Layout layoutMd = (Metadata.Layout) accountLayout.get(0);
for (Metadata.LayoutSection section : layoutMd.layoutSections) {
System.debug('Section: ' + section.label);
for (Metadata.LayoutColumn column : section.layoutColumns) {
if (column.layoutItems != null) {
for (Metadata.LayoutItem item : column.layoutItems) {
System.debug('Field: ' + item.field);
fields.add(item.field);
}
}
layoutFieldsMap.put(section.label, fields);
fields.clear();
}
}
System.debug('fields map: ' + layoutFieldsMap); //fields is getting nulled out. figure it out.
for(String key : layoutFieldsMap.keySet()){
List<String> f = layoutFieldsMap.get(key);
System.debug('key: ' + key);
System.debug('f: ' + f);
}
Get Limits For The Org
//Get list of what limits are available.
List<System.OrgLimit> limits = OrgLimits.getAll();
for (System.OrgLimit aLimit: limits) {
System.debug('Limit Name ' + aLimit.getName());
}
Map<String,System.OrgLimit> limitsMap = OrgLimits.getMap();
System.OrgLimit dataStorageLimit = limitsMap.get('DataStorageMB');
System.OrgLimit fileStorageLimit = limitsMap.get('FileStorageMB');
// Max and usage limit values of dataStorageLimit
System.debug('dataStorageLimit Value: ' + dataStorageLimit.getValue());
System.debug('Maximum Limit: ' + dataStorageLimit.getLimit());
// Max and usage limit values of fileStorageLimit
System.debug('fileStorageLimit Value: ' + fileStorageLimit.getValue());
System.debug('Maximum Limit: ' + fileStorageLimit.getLimit());
Get Number Of Users Assigned To Each Permission Set
SELECT PermissionSet.Name, Count(Id) From PermissionSetAssignment
WHERE Assignee.isActive = true
AND PermissionSet.IsOwnedByProfile = false
Group By PermissionSet.Name
Order By Count(Id) DESC
Get Number Of Users Assigned To Each Profile
SELECT count(Id), Profile.Name
FROM User GROUP BY Profile.Name /* NOTE: make sure to filter by active users if you want only active users */
Export Object Level Permissions For All Profiles And Permission Sets - Data Loader
SELECT Parent.Profile.Name, Parent.Label, Parent.IsOwnedByProfile, SobjectType, PermissionsRead, PermissionsCreate, PermissionsEdit, PermissionsDelete, PermissionsViewAllRecords, PermissionsModifyAllRecords
FROM ObjectPermissions
ORDER BY Parent.Profile.Name, Parent.Label, SobjectType
Export Field Level Security For All Profiles And Permission Sets - Data Loader
SELECT Parent.Profile.Name, Parent.Label, Parent.IsOwnedByProfile, SobjectType, Field, PermissionsEdit, PermissionsRead
FROM FieldPermissions
ORDER BY Parent.Profile.Name, Parent.Label, SobjectType, Field
Get List Of Apps
SELECT Id, ApplicationId, Name, Label, Type FROM AppMenuItem WHERE type='TabSet'
/* NOTE: remove where clause to see all application types (Network, Connected Apps, etc.). TabSet is for Salesforce Apps created for users */
Get List Of Profiles With Access To Apps
SELECT Id, SetupEntityId, ParentId, Parent.Label, Parent.IsCustom, Parent.IsOwnedByProfile, Parent.ProfileId, Parent.Profile.Name
FROM SetupEntityAccess
WHERE SetupEntityType = 'TabSet' AND Parent.IsOwnedByProfile = true
ORDER BY Parent.ProfileId