Truques de CLI mais úteis do Salesforce

Apr 24 2023
.
Truques de CLI mais úteis do Salesforce
  1. Obter campos sObject para serem usados ​​no formato de consulta: sfdx + jq
  2. # example for Account
    sfdx sobject describe --sobject Account | jq --raw-output '.fields|map(.name)|join(",")'
    
           
                    
    Account Fields

    sfdx data query --query \"SELECT Id,Action,Section,CreatedDate,CreatedBy.Name,Display FROM SetupAuditTrail ORDER BY CreatedDate DESC\" --resultformat csv > _SetupAuditTrail.csv
    

    ./scripts/sh/deleteApexLog.sh
    
    ------
    
    sfdx force:data:soql:query -q "SELECT Id FROM ApexLog" -r "csv" > outApexLog.csv
    sfdx force:data:bulk:delete -s ApexLog -f outApexLog.csv
    rm outApexLog.csv
    

    sfdx force apex execute --file scripts/apex/switchDebugMode.apex
    
    ----
    
    Boolean current = [SELECT UserPreferencesUserDebugModePref FROM USER WHERE Id =: UserInfo.getUserId() ].UserPreferencesUserDebugModePref ; 
    update new User(Id = UserInfo.getUserId(), UserPreferencesUserDebugModePref= !current);
    

    sfdx force:apex:test:run --codecoverage --detailedcoverage --resultformat junit --wait 30 > tests.xml
    npx xunit-viewer -r tests.xml
    

    myAlias=<fill your alias here>
    
    for row in $(sfdx force:data:soql:query -q "SELECT Id FROM TraceFlag" --usetoolingapi --resultformat "json" | jq -r '.result.records | .[].Id' ) 
        do  
            echo sfdx force:data:record:delete --sobjecttype TraceFlag --sobjectid ${row} --targetusername ${myAlias}
            sfdx force:data:record:delete --usetoolingapi --sobjecttype TraceFlag --sobjectid ${row} --targetusername ${myAlias}
        done