Address Field in Lead Object
Address Field in Lead object is a Compound Field. 1. Street2. State3. PostalCode 4. Country SOQL: SELECT Street, State, PostalCode, Country FROM Lead
Tag: Salesforce SOQL
INCLUDES keyword in SOQL
INCLUDES keyword is used as filter for multi-select picklist in Salesforce. Sample Query: SELECT Name, AccountNumber, Territories__c FROM Account Where Territories__c INCLUDES ('North','South','') here North, South and '' are values. ....
Difference between SOSL and SOQL
SOSL stands(Salesforce object search language) SOQL stands for(Salesforce object query language) Works on multiple objects at the same time. Need to write different SOQL for multiple objects. Cannot be used ....
LIKE operator in Salesforce SOQL
In SOQL, the LIKE operator is supported for string fields only. So, we cannot use it against any other field data types. Syntax: String strSOQL = 'SELECT FieldAPIName FROM sObject ....
Getting child objects of parent object in Salesforce
getChildRelationships() can be used to retrieve all the related or child objects of an object in Salesforce Apex. Sample code: Schema.DescribeSObjectResult objResult = Account.SObjectType.getDescribe(); List < Schema.ChildRelationship > objRelationships = ....
Like Operator usage in Apex
In SOQL, the LIKE operator is supported for string fields only. So, we cannot use it against any other field data types. Example: String sql = 'Select Name From Account ....