Skip to content
/ Salesforce-Utils Public

Repository with tools, tricks, commands and resources for Salesforce development and administration.

0 stars 0 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

manvil95/Salesforce-Utils

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

84 Commits
docs
docs
 
 
img
img
 
 
scripts
scripts
 
 
Commands.md
Commands.md
 
 
README.md
README.md
 
 
package.xml
package.xml
 
 

Repository files navigation

Salesforce-Utils



Repository with tools, tricks, commands and resources for Salesforce development and administration.

Table of content

LWC

Tip

Evita Visualforce Page. 😊

LWC Debug

Pasos DEBUG LWC

  1. Debug mode -> Seleccionar usuario y habilitar (Permite ver el JS direcamente en la consola del navegador, pudiendo podificar, debugear, etc)
  2. Session settings -> Caching | Enable Secure persistent browser caching to improve performance:False (Permite que puedas refrescar sin que se te mantenga la Cache)
  3. Session Settings -> Lightning Web Security | Use Lightning Web Security for Lightning web components and Aura components:False

Organization - Production - Sandbox

Standard - Custom Objects

Formula Fields

Cuando se desee mostrar correctamente el label en vez de el APIName de una picklist, utilizar funcionalidades de las fórmulas. Ej.: Tengo una picklist que muestra los valores como: A-Suceso, B-EspacioBlanco-B12. Si se desea poner espacios entre los guiones, la fórmula debería ser así:

IF(
    CONTAINS(Text(RelatedObject__r.PicklistField__c), '-'),
    SUBSTITUTE(
        SUBSTITUTE(
            Text(RelatedObject__r.PicklistField__c),
            '-',
            ' - '
        ),
        '  -  ',
        ' - '
    ),
    Text(RelatedObject__r.PicklistField__c)
)

ORG Doctor

To check org's status: ORG Doctor

Grant Salesforce Support login access to your organization

  1. In the upper right, click your image (avatar) and then click Settings.
  2. In Quick Find search field, enter "Grant" and click Grant Account Login Access.
  3. Set the Access Duration option to Salesforce.com Support. Note: It is recommended to set the Access Duration to one month for technical escalations. It can be extended later if needed.
  4. Click Save.

Salesforce Help

Apex

Search all lookups in other objects

List<String> referencedFields = new List<String>();
Map<String, Schema.SObjectType> gd = Schema.getGlobalDescribe();

for (Schema.SObjectType sot : gd.values()) {
  Schema.DescribeSObjectResult objResult = sot.getDescribe();
  Map<String, Schema.SObjectField> fields = objResult.fields.getMap();
  
  for (String fieldName : fields.keySet()) {
    Schema.DescribeFieldResult fieldResult = fields.get(fieldName).getDescribe();
    Schema.DisplayType fieldType = fieldResult.getType();
    
    if (fieldType == Schema.DisplayType.Reference) {
      List<Schema.SObjectType> referenceTo = fieldResult.getReferenceTo();
      for (Schema.SObjectType ref : referenceTo) {
        if (ref.getDescribe().getName().equals('NombreDelObjeto')) {
          referencedFields.add(objResult.getName() + '.' + fieldName);
          System.debug('FIELD: ' + objResult.getName() + '.' + fieldName);
        }
      }
    }
  }
}

System.debug('FIELDS: ' + referencedFields);

Code review checklist

Expert code review

Postman

Postman for Salesforce Developers. Postman Workspace

Reach query limits

If you are going to reach the limit of queries per DML in loop:

  1. Set method -> last in the Trigger Handler.
  2. Control with next if and break process.
  3. Invoke error control framework if there is one.
if (Limits.getQueries() < Limits.getLimitQueries() {
  insert sObjectList;
}
else {
  ErrorLog__c.insertError();
  break;
}

Test an .AddError()

Test.startTest();
try {
  update workOrder;
  Assert.fail('The update did not fail');
} catch (DmlException e) {
  Assert.isTrue(e.getMessage().contains(Label.FailLabel), 'The error is not the propper one');
}
Test.stopTest();

Developer console doesn't show logs

When the 'Developer Console' does not show any log and freezes, this is what to do1: if you have any Chromium based browser such as Chrome, edge, opera, etc. you have to open the dev tools from the console, open the network section and refresh and magically it is solved:

  1. Login and open Developer Console by Chrome
  2. Open Developer tools and select Network
  3. Reload on Developer Console

Trigger Frameworks

  • Dan Appleman2
  • Hari Krishnan3
  • Scot Wells4
  • O'Hara5
  • Mitch Spano6

SOQL

Chain LIKE and NOT LIKE

# Forma de encadenar varios LIKE y NOT LIKE
SELECT Name
FROM Object
WHERE (NOT Name LIKE 'ST%')
  AND (NOT Name LIKE 'PA%')

# Bind 
SELECT Name FROM Object
WHERE (NOT Name LIKE 'ST%')
  AND (Name NOT IN :var)

Subquery examples

SELECT Name 
FROM Account 
WHERE Id NOT IN 
  (
    SELECT AccountId 
    FROM Opportunity 
    WHERE IsClosed = true
  )

Search by KeyPrefix

SELECT Id, DeveloperName
FROM EntityDefinition
WHERE KeyPrefix = 'XXX'

Search Entities and Fields

To search all fields in all objects, even deleted ones.

SELECT Id, DeveloperName, EntityDefinition.DeveloperName
FROM CustomField

See scratch-org expiration

SELECT Id, TrialExpirationDate
FROM Organization

Naming convention

Object Fields

Field Type API Name
Auto Number AUT_AutoNumberField__c
Boolean FLG_BooleanField__c
Currency DIV_CurrencyField__c
Date & DateTime DAT_DateTimeField__c
Email EMA_EmailField__c
Formula FOR_FormulaField__c
Geolocation GEO_GeolocationField__c
Lookup LKP_LookUpField__c
Master-Detail Relationship MDR_MasterDetailField__c
Multi-Select Picklist MSE_MultiSelectField__c
Number NUM_NumberField__c
Percent PER_PercentField__c
Phone TEL_PhoneField__c
Picklist SEL_PicklistField__c
Roll-Up Summary RUS_RollUpSummaryField__c
Text TXT_TextField__c
Time HOR_TimeField__c
URL URL_URLField__c

Metadata

Metadata Type API Name
Custom Label LAB_LabelName
Custom Metadata CMT_CustomMetadataName
Custom Setting CS_CustomSettingName
Event LEV_EventName
External Credential EC_ExtCredentialName
Flow FLW_FlowName
Lightning Page LP_PageName
List View LV_ListViewName
Named Credential NC_NamedCredentialName
Path PTH_PathName
Tab TAB_TabName
Validation Rule VR_PathName
Workflow WF_ObjectNameProcess

Trigger and Classes

Metadata Type API Name
Trigger TRG_TriggerName
Trigger Handler TRG_ClassNameHandler
Helper TRG_ClassNameHelper
Batch BATCH_ClassName
Scheduler SCH_ClassName
Interface INT_InterfaceName
Test ClassAPIName_Test
Test Suite TestSuiteName_TestSuite

Visualforce

Metadata Type API Name
Visualforce Page VFP_PageName
Visualforce Controller VFC_ControllerName
Visualforce Controller Test ControllerAPIName_Test

List of common API suffixes in Salesforce

API Suffixes7 Used for
__c Object / Field
__r Relationship
__e Events
__b Big Objects
__mdt Custom Metadata Type
__x External Object
__share Sharing Object
__Tag Salesforce Tags
__voteStat Rating for an article
__viewStat Number of view per article
__kav Knowledge Article Objects
__history Field History Tracking
__xo Salesforce-to-Salesforce (S2S) spoke
__pc Custom Persona Account Field
__ChangeEvent Change Data Capture
__StateCode__s Custom Address field
__CountryCode__s Custom Address field
__Street__s Custom Address field
__PostalCode__s Custom Address field
__City__s Custom Address field
__GeocodeAccuracy__s Custom Address field
__dlm (Data Model Object) for the Customer Data Platform.
__chn Change Event channel
__latitude__s Latitude Coordinate
__longitude__s Longitude Coordinate

VS Code

Tricks

Tip

It is recommended to have the following line in your settings.json to detect conflicts before deploying to the ORG.

"salesforcedx-vscode-core.detectConflictsAtSync": true,

Unable to get issuer cert locally

Caution

Al hacer sfdx force:org:list aparece ese error.

Solution: add this environment variable NODE_TLS_REJECT_UNAUTHORIZED = 0

My settings.json

{
    "[json]": {
        "editor.defaultFormatter": "vscode.json-language-features"
    },
    "[xml]": {
        "editor.defaultFormatter": "DotJoshJohnson.xml"
    },
    "apexPMD.runOnFileOpen": true,
    "better-comments.tags": [
        {
            "backgroundColor": "transparent",
            "bold": true,
            "color": "#FF2D00",
            "italic": false,
            "strikethrough": false,
            "tag": "!",
            "underline": true
        },
        {
            "backgroundColor": "transparent",
            "bold": true,
            "color": "#C848CE",
            "italic": false,
            "strikethrough": false,
            "tag": "-->",
            "underline": false
        },
        {
            "backgroundColor": "transparent",
            "bold": true,
            "color": "#3498DB",
            "italic": false,
            "strikethrough": false,
            "tag": "?",
            "underline": false
        },
        {
            "backgroundColor": "transparent",
            "bold": false,
            "color": "#474747",
            "italic": false,
            "strikethrough": true,
            "tag": "//",
            "underline": false
        },
        {
            "backgroundColor": "transparent",
            "bold": true,
            "color": "#FF8C00",
            "italic": false,
            "strikethrough": false,
            "tag": "todo",
            "underline": false
        },
        {
            "backgroundColor": "transparent",
            "bold": true,
            "color": "#98C379",
            "italic": false,
            "strikethrough": false,
            "tag": "*",
            "underline": false
        }
    ],
    "codesnap.showWindowControls": false,
    "codesnap.shutterAction": "copy",
    "codesnap.target": "window",
    "diffEditor.maxComputationTime": 0,
    "editor.bracketPairColorization.independentColorPoolPerBracketType": true,
    "editor.cursorBlinking": "expand",
    "editor.cursorSmoothCaretAnimation": "on",
    "editor.fontFamily": "JetBrains Mono, Victor Mono, Consolas, 'Courier New', monospace",
    "editor.fontLigatures": "'ss01', 'cv03', 'zero'",
    "editor.glyphMargin": false,
    "editor.guides.bracketPairs": true,
    "editor.indentSize": "tabSize",
    "editor.minimap.autohide": true,
    "editor.minimap.maxColumn": 60,
    "editor.occurrencesHighlight": "multiFile",
    "editor.overviewRulerBorder": false,
    "editor.scrollbar.verticalScrollbarSize": 8,
    "editor.stickyScroll.defaultModel": "indentationModel",
    "editor.stickyScroll.enabled": true,
    "editor.stickyScroll.maxLineCount": 10,
    "files.autoSave": "afterDelay",
    "git.confirmSync": false,
    "prettier.tabWidth": 4,
    "salesforcedx-vscode-apex.java.home": "",
    "salesforcedx-vscode-core.detectConflictsAtSync": true,
    "security.workspace.trust.untrustedFiles": "open",
    "settingsSync.ignoredExtensions": [],
    "symbols.hidesExplorerArrows": false,
    "terminal.integrated.stickyScroll.enabled": true,
    "window.zoomLevel": 1,
    "workbench.colorCustomizations": {
        "editor.lineHighlightBorder": "#ffffff1f"
    },
    "workbench.colorTheme": "Night Owl",
    "workbench.iconTheme": "material-icon-theme",
    "workbench.productIconTheme": "fluent-icons",
    "workbench.settings.applyToAllProfiles": [],
    "workbench.sideBar.location": "right",
    "workbench.tree.enableStickyScroll": true,
    "workbench.tree.stickyScrollMaxItemCount": 10,
    "xml.symbols.maxItemsComputed": -5000
}
References

Footnotes

  1. Developer Console menus are unresponsive ↩

  2. Dan Appleman - Triggers without frameworks ↩

  3. Hari Krishnan ↩

  4. Scott Wells ↩

  5. O'hara ↩

  6. Mitch Spano ↩

  7. Suffixes in Salesforce ↩

About

Repository with tools, tricks, commands and resources for Salesforce development and administration.

Topics

salesforce salesforce-developers salesforce-administration

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages