thiscodeWorks - Organizing the best of code online

List view

#salesforce #static #keywords #class #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

Parent Child SOQL

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

Save snippets that work with our extensions