thiscodeWorks - Organizing the best of code online

List view

SELECT Id FROM User WHERE Name = 'System'

#salesforce #apex #soql

SOQL - Apex Debug logs

SELECT Id,LogUser.Name, LogLength,Application,Status,DurationMilliseconds,StartTime,RequestIdentifier 
FROM ApexLog 
ORDER BY StartTime DESC

#salesforce #flows #soql

Mass delete Salesforce Flow versions

SELECT DurableId, FlowDefinitionView.Label, VersionNumber, Status FROM FlowVersionView WHERE FlowDefinitionView.Label LIKE '%PLACE PART OF THE FLOW NAME HERE%' AND Status != 'Active'



/* NOTE: When IMPORTING (Delete Action) - Mark API Type as "Tooling API", limit the batch to 10 and 1 thread (SF Limitation), and change DurableId to ID */

#salesforce #static #keywords #class #soql

Parent Child SOQL

Select id, name, Parent__r.name, Parent__r.id from Child__c

Select id, name, Parent__r.name,(SELECT id, name, amount__c FROM Children__r) from Parent__c

#apex #salesforce #soql

Custom Object Parent -> Child, Chile -> Parent Queries

//Parent to Child
SELECT Name, (SELECT name FROM Sessions__r) FROM Public_Event__c
//Child to Parent
SELECT id, name, Public_Event_Name__r.name, Public_Event_Name__r.id From Sessions__c

Find "System" (Email-to-Case) User ID

SOQL - Apex Debug logs

Mass delete Salesforce Flow versions

Parent Child SOQL

Custom Object Parent -> Child, Chile -> Parent Queries

Save snippets that work with our extensions