Difference between SOQL and SOSL
SOQL SOSL SOQL is used if we know in which object the data is present. SOSL is used if we don't know in which object the data is present. In ....
Tag: Salesforce SOQL
FOR REFERENCE in SOQL
FOR REFERENCE is used to notify Salesforce when a record is referenced. The LastReferencedDate field is updated for any retrieved records. Sample Query: SELECT City__c, State__c, LastReferencedDate FROM Employee__c FOR ....
Alias Notation in Salesforce SOQL
Alias Notation is allowed in Salesforce SOQL. In the following sample SOQL, I have used Con as alias for Contact object and Acct for the Account object. Sample SOQL: SELECT ....
CreatedBy and CreatedDate in SOQL
CreatedDate: Created Date Time of the record. CreatedById: Id of the user who created the record. Sample SOQL: SELECT Id, CreatedDate, CreatedById, CreatedBy.Name FROM Account LIMIT 5
How to sort null values at last in SOQL?
Generally in SOQL, null values are sorted first. In order to sort null values at last make use of NULLS LAST keyword. Sample SOQL: SELECT Id, Name, Industry FROM Account ....
Query to fetch Role name and Profile Name from User Object
SOQL: SELECT UserRole.Name, Profile.Name FROM User Output:
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
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 ....