SOQL and SOSL Difference

SOQL and SOSL Difference in Salesforce

The following table describes about the SOQL and SOSL difference

SOQL Query Examples:-

-A SOQL query is enclosed between square brackets the following query retrieves an subjects (a record from the database) that has the name field value equal to “Osmania University” Account a = "select Id name FROM account where name = 'Osmania University' "           Return type     Query (Applicable for only one record) Note:- In the above the “a” variable stores the ID ,Name of all accounts with name=’Osmania University’ Note:- SOQL Statement evaluate to a list of SObjects single SObjects or an integer for count method queries. LIst of SObject à List < Position_c Position = "select name from position_c shwre type_c='part time'"; Single sumbject: Postion_c p="select name from position_c where id='xxxxx'" Integer: Integer i="select countc,from position_c where c type_c='part time'" SOQL Bindings:-Square bracketed queries support binding to Apex variable String jobtype='Full Time'; List<position_c> S="select name from position_c where type_c=:job type;"

Enthusiastic about exploring the skill set of Salesforce? Then, have a look at the blog post to gather additional knowledge on Salesforce Training and Certification.

SOSL Queries

SOSLà sales force object search language

• SOSL statements evaluate to a list of lists of SObjects where each list contains the search results for a particular sobject type

• SOSL queries are only supported in Apex classes and anonymous blocks.
• We cannot use a SOSL query in a trigger

The folloing exapmle that searches all fields across all account and contact objects. Ex:- LIst<List<Sobject>> searchist="Find 'Text*' IN ALL FIELDS RETURNING Account, Contact Systerm.debug(Serachlist);" This query will search the account and contact records that field values starts with test in all fileds.

• The following example returns a list of accounts, contacts, opportunities and leads that begin with the phrase map.

LIst<List<Sobject>> searchist=[Find 'map*' IN ALL FIELDS RETURNG Account(ID, Name),contact,opportunity,Lead]; System.debug(searchist); Account(ID, Name)--> this means it returns the account records with ID, name values Note:-   If a SOSL query does not return any records for a specified SObject type, the search results include an empty list for that SObject Updated Operation: The update DML operation modifies one or more existing SObject records, DML (update) statement syntax Update SObject; Update Subject[ ]; The following example describes us about an updating an account field through an existing contact that has also been modified here two update statements are required // use a SOQL Query to access data for a contact Contact C=[SELECT Account.Name FROM contact where Last Name ='Anil' LIMIT 1]; C.Account.Name='Capital info Solutions'; C.Lastname='sateesh'; --->The above two statements says that change in fields for both contact and its associated account Upadate C:--> updates the contact. Update C.Account: --> Update the Account. System.Debug(c); System.debug(c.Account.Name);

• The following example updating account fields through the API

Access a="select name,Rating,Industry FROM Account Where id='xxxxx';" /*This query retrieves the Name, Rating, Industry fields values of one particular account*/ a.Name='Osmania University'; a.Rating='Hot'; a.Industry='Electrical'; Update a; System debug(a) Note:- Account a ="select name; Phone FROM Account where id='xxxx';" System.debug(a.Industry) No compilation error, but it gives run time error like SObject row was retrieved via SOQL without querying the requested filed.

Delete Operation:-

 The delete DML operation deletes one or more existing SObject records, such as individual accounts or contacts, from organization’s data. The DML (Delete) statement syntax is Delete SObject; Delete SObject[]; The following example is to delete the account record through the API //First get the account record which we want to delete Account a =" select ID from account where name='Osmania University' LIMIT 1;" Delete a;* The DML Operation deletes the above record.*/

• Deleting a record places it in the recycle bin from where we can restore it. Records in the Recycle bin are temporarily stored for 15 days before they are permanently deleted.

• To restore just use the undelete DML statement .Notice that we used the ALL ROWS keywords in the SOQL query to be able to retrieve the delete record.

Account a =" select name FROM account where name='Osmania University' ALL Rows;" UnDelete a; Note:- Comments:-: - Comments are lines of text that we add to code to describe what it does comments are not executable code. It’s a good practice to annotate code with comments as necessary. Apex has two forms of comments

1. The first uses the // token to mark everything on the same line.

2. The second encloses a block of text, possibly across Multiple lines between the /* and */ tokes

The following example describes only the debug statement runs: System.debug (‘capital info solutions ‘); //This comment is ignored. /* Hi All, All the Best From capital info solutions */

Case Sensitivity:-

• Apex is case insensitive this means that all apex code, including method names class names, variable names and keywords, can be written without regard to case

EX:- Integer Myvar; IntegER MYVAR;     --->both are equivalent statements The following statements print out today’s date using the System today method when we execute them in the Developer Console. System.debug(System.today()); System.debug(System.Today()); System.debug(System.TOday()); Note- A good practice is for class names to start with an uppercase letter and method names to start with a lowercase letter.

For indepth understanding on Salesforce click on

• Salesforce Tutorials
• SalesForce Interview Questions & Answers
• Annotations in SalesForce
• Loops in SalesForce
• Apex Data Manipulation
• Creating Apex Classes
• Salesforce Training In Dallas