Use subquery in SOQL
- Jul
- 28
- Posted by Lin
- Posted in Salesforce, SOQL

Salesforce allows us to use subquery in SOQL. The following soql is a sample, shows how to filter out Parent Records that don’t have a related child with subquery. And subquery also works in Related(Lookup) Objects, e.g. Be attention that the object name have to be Child Relationship Name when subquery SELECT as a field, […]
read moreRecent Posts
- Using Promise for Apex Server-Side request in Lightning Component
- Pipeline for Salesforce – Be less busy, less mistake in Salesforce metadata deploy
- Salesforce Smart Importer – 1-Drag to import Excel / CSV in Salesforce, supports both Classic and Lightning!
- Setup Salesforce DX IDE environment with Visual Studio Code
- Works with Salesforce Developer Experience (DX)
Top Posts
- Setup an awesome Salesforce developer environment with Sublime Text 3 - 83.2K views
- Salesforce DevTools – Powerful Chrome extension for Saleforce.com developer - 38.2K views
- Salesforce Mass Editor (Chrome Extension) – Mass create, mass update, mass clone, mass delete on any list view. Support for both Classic and Lightning! - 28.5K views
- Date format and DateTime format - 26.4K views
- How to access static resources from Apex, Visualforce and Custom Button - 25.7K views
Categories
- APEX
- Apps
- Custom Label
- Custom Metadata
- Custom Setting
- Design & UI
- Event
- Heroku
- iOS & Object-c
- Lightnint Component
- Linux & Mac OS
- Metadata API
- Node.js
- Open Source
- Other
- PHP Framework
- Release Notes
- REST API
- Salesforce
- Salesforce DX
- SOQL
- Tesforce
- Tooling API
- Unit Tests
- Validation Rule
- Visualforce
- WordPress