mjhjmtu

While preparing myself to the Developer 1 certification I met the following question:

A developer needs to write a method that searches for a phone number that could be on multiple object types. Which method should the developer use to accomplish this?

A) SOSL Search

B) SOQL Query on each object

C) SOQL Query that includes ALL ROWS

D) SOSL Search that includes ALL ROWS

It is clear from on multiple object types that we need to use SOSL. So, we are left with A) and D). I do not know which one of them is correct.

After googling, here is what I found:

SOQL statements can use the ALL ROWS keywords to query all records in an organization, including deleted records and archived activities.

And I was not able to find the ALL ROWS in the context of SOSL. So, is it possible to use ALL ROWS in SOSL query? And if it is, will it have the same effect as using it in SOQL?

Answer is "A".

You can't use ALL ROWS option in SOSL and but you can use this option in SOQL and it retrieve all the records inculding deleted one if it's in recycle bin.

Answer will be A) SOSL Search

As, SOSL with All rows doesn't make any sense.

Here is the Scope of fields to search. One of the following values:

• ALL FIELDS


• NAME FIELDS


• EMAIL FIELDS


• PHONE FIELDS


• SIDEBAR FIELDS

Refer RETURNING FieldSpec

RETURNING ***ObjectTypeName*** 
[(FieldList [WHERE conditionExpression] [USING Listview=listview name] [ORDER BY Clause] [LIMIT n] [OFFSET n])] 
[, ObjectTypeName [(FieldList [WHERE conditionExpression] [ORDER BY Clause] [LIMIT n] [OFFSET n])]]

SOSL search is similar to Global Functionality which Salesforce provides and it doesn't search using ALL ROWS unlike SOQL.