Timeline for SOQL Best Practices with Multiple Junction Objects
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 30, 2015 at 13:17 | comment | added | SamMoreira | Thanks CoryCowgill and LaceySnr. I was able to get all the data in one query as suggested while applying all requested junction filters during this one call. Then I used a map to validate the records returned and removed from the map any main object records that didn't return at least one record from each one of the requested junction objects. After processing, the map only had the main object records that met all requested filter criteria, exactly like the corresponding SQL query. The performance was also a lot better than my first approach of making multiple calls. Thanks for your help. | |
| Apr 30, 2015 at 12:44 | vote | accept | SamMoreira | ||
| Apr 28, 2015 at 6:17 | history | edited | Matt Lacey♦ | CC BY-SA 3.0 |
added 37 characters in body
|
| Apr 27, 2015 at 20:10 | history | answered | CoryCowgill | CC BY-SA 3.0 |