Two ways to use SOQL IN clause
- Nov
- 09
- Posted by Lin
- Posted in APEX, Salesforce, SOQL
With binding set of Ids We can have a simple SOQL statement like this: Or direct from keySet of Map With binding list of sObjects Actually,There has another way to use IN clause like this: Enjoy it!
read moreUse 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 moreGroup by multiple fields in SOQL
- May
- 11
- Posted by Lin
- Posted in Salesforce, SOQL

In this post I’ll show you the useage of Group By in SOQL. *Amazingly,SOQL supports groupping with multiple fields.The data I have prepared the data by Saels__c sObject, whose Account__c field is reference to Account,User__c field is reference to User, and Amount__c field is a Currency field. Group By 1.Simple Group BY 1.Group by two […]
read moreRecent Posts
- Salesforce DevTools JUST HIT 10,000 USERS! THANK YOU!
- 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
Top Posts
- Setup an awesome Salesforce developer environment with Sublime Text 3 - 101.8K views
- Salesforce DevTools – Powerful Chrome extension for Saleforce.com developer - 97.7K views
- Salesforce Mass Editor (Chrome Extension) – Mass create, mass update, mass clone, mass delete on any list view. Support for both Classic and Lightning! - 63.1K views
- Date format and DateTime format - 55.2K views
- Writing a Schedulable Batch Apex in Salesforce - 49.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