Saturday, September 23, 2023
HomeUncategorizedSalesforce | All You Have to Know About SOSL and Associated Data...

Salesforce | All You Have to Know About SOSL and Associated Data in Apex

[ad_1]

On this weblog, we’ll focus on what are associated data in Salesforce and what we understood by SOSL in apex

What are Associated Data in Apex?

Inserting Associated Data 

Instance :

Account acc = new Account(Identify=’abc’, Telephone = ‘123456’); 
insert acc; 
Contact con = new Contact(Account=acc.Id, FirstName = ‘abc’ , LastName = ‘xyz’, Telephone = ‘12345’); 
Insert con;

Updating Associated Data 

Contact con = [SELECT Id, Name,Account.Phone FROM Contact WHERE Name = ‘abc’ AND AccountId!=Null AND Account.Name = ‘Account1’];  
Con.Telephone=’111’; 
Con.Account.Telephone=’2222’; 
replace con; 
replace con.Account;

dont miss out iconDo not forget to take a look at: Learn All About Salesforce Apex Programming

Now, let’s transfer to SOSL!

What’s SOSL in Apex?

  • SOSL stands for Salesforce Object Search language. 
  • It’s used to carry out a textual content search in data. 
  • We are able to use SOSL to go looking fields throughout a number of sObjects data. 
  • SOQL is used to retrieve data for a single object whereas use SOSL to go looking fields throughout a number of objects. 

Syntax 

Discover ‘SearchQuery’ [IN SearchGroup] [RETURNING ObjectsAndFields];

What’s a SearchQuery?

  • Single Phrase: It ought to be enclosed in single quotes. 
  • Phrase: It’s having a number of phrases and ought to be enclosed in double quotes. 

What’s a SearchGroup?

SearchGroup is optionally available. 

  • The default is ALL FIELDS. 
  • You’ll be able to select from the next search teams: 
  • ALL FIELDS 
  • NAME FIELDS 
  • EMAIL FIELDS 
  • PHONE FIELDS 
  • SIDEBAR FIELDS 

ObjectsAndFields 

  • ObjectsAndFields is optionally available. 
  • It’s the info to return within the search end result – a listing of a number of sObjects and inside every sObject, record of a number of fields, with optionally available values to filter in opposition to. 
  • If not specified the search end result comprise the IDs of all objects discovered. 

dont miss out iconTake a look at one other superb weblog by Bhawana right here: All You Need to Know About Database Class Methods to Perform DML Operations

Execute Nameless Window 

Listing<Listing<sObject>> searchList = [FIND ‘Cloud’ IN ALL FIELDS RETURNING Account(Name),Contact(FirstName, Lastname, Email)];

Question Editor 

FIND {Cloud} IN ALL FIELDS RETURNING Account(Identify), Contact(FirstName, LastName, E-mail)];

For instance:

Listing<Listing<sObject>> searchList = [FIND ‘Abc’ IN ALL FIELDS RETURNING Account(Name), Contact(FirstName,LastName,Email)]; 
Listing<Account> accList = new Listing<Account>(); 
Listing<Contact> conList = new Listing<Contact>(); 
accList = (Listing<Account>) searchList[0]; 
conList = (Listing<Contact>) searchList[1]; 
for(Account acc : accList)
{ 
    System.debug(‘Identify =>' + acc.Identify); 
} 
for(Contact con : conList)
{ 
    System.debug(con.FirstName + ‘ ‘ + con.LastName); 
}

So, that is all about associated data in apex and SOSL. I hope this info is useful to you. 



[ad_2]

Source link

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments