Sample Apex Code:String searchQuery = 'FIND {test} IN Name FIELDS RETURNING Account( Id, Name ), Contact( Id, Name )';List < List < sObject > > searchResult = search.query( searchQuery );List ....
Don't use SOQL to find or query records using phone numbers. Instead, use SOSL. SOSL Example: FIND {7894561237} IN Phone FIELDS RETURNING Account( Name, Phone, Other_Phone__c ) Sample Apex Code: ....
1. Open Developer Console and select Query Editor tab. 2. Enter the SOSL and click Query.
Use convertCurrency() in a SOSL query to convert currency fields to the user’s currency. This action requires that the organization is multi-currency enabled. Syntax: convertCurrency(Amount) Example: FIND {test} RETURNING Opportunity(Name, ....
Dynamic SOSL refers to the creation of a SOSL string at run time with Apex code. Dynamic SOSL enables you to create more flexible applications. Sample SOSL: String strName = ....
The return type of a SOSL search is List of List of sObjects. Sample Code: List<List<SObject>> searchList = [FIND 'map*' IN ALL FIELDS RETURNING Account (Id, Name), Contact, Opportunity, Lead]; ....
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 ....
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 ....
Examples: Example 1: FIND {test*} IN ALL FIELDS RETURNING Account (Id, Name), Contact, Opportunity, Lead Searches field values starting with the keyword 'test' in all fields in Account, Contact, Opportunity, ....
Unlike SOQL, which can only query one object at a time and multiple objects only if they are related to each other, SOSL enables you to search text, email, and ....