SOSL

Question 1

What does SOSL stand for?

Answer 1

Salesforce Object Search Language

Question 2

When is SOSL used?

Answer 2

SOSL can be used when the object or field where the searched data resides in is not known.

Question 3

What three field types does SOSL allow searching on?

Answer 3

SOSL allows searching text, email, and phone fields across multiple objects simultaneously.

Question 4

The ______ and _______ to be searched and fields to be returned can be specified.

Answer 4

objects, fields

Question 5

What clause is used to specify the word or phrase to search for?

Answer 5

The FIND clause.

Question 6

The optional _________ clause can be used to specify the information to be returned.

Answer 6

RETURNING

Question 7

What three clauses can be used for specific text searches?

Answer 7

In, Where, Limit

Question 8

What is the return type of a SOSL query?

Answer 8

Each SOSL query returns a list of lists of sObjects. A variable of type List<List<SObject>>can be used to store the results of a SOSL query in Apex.</SObject>

Question 9

Example SOSL Query:

Answer 9

FIND {test} RETURNING Account (Id), Contact, Opportunity LIMIT 60

Question 10

If we want to include fields in the search what clause would we use?

Answer 10

The IN Clause.

Question 11

The types of text fields to search for using SOSL can be specified through the optional __________ clause.

Answer 11

IN SearchGroup

Question 12

When using the SearchGroup phrase ________. All searchable fields are searched. It is the default setting if the IN clause is not specified.

Answer 12

ALL FIELDS

Question 13

When using the SearchGroup phrase ________. Only email fields are searched.

Answer 13

EMAIL FIELDS

Question 14

When using the SearchGroup phrase ________. Only name fields on standard and custom objects are searched. Some additional fields such as ‘Website’ and ‘Site’ on Account and ‘Company’ on Lead are also searched.

Answer 14

NAME FIELDS

Question 15

When using the SearchGroup phrase ________. Only phone number fields are searched.

Answer 15

PHONE FIELDS

Question 16

When using the SearchGroup phrase ________. Only valid records as listed in the sidebar drop-down list (Salesforce Classic only) are searched.

Answer 16

SIDEBAR FIELDS

Question 17

Example using SearchGroup Phrasing:

Answer 17

FIND {Marcus} IN NAME FIELDS

Question 18

The ______ clause is used to search and only return records that match a specified criteria.

Answer 18

WHERE

Question 19

WHERE Clause Example:

Answer 19

FIND {test} RETURNING Account (Id WHERE Rating = ‘Hot’)

Question 20

The optional _____ clause can be added to a query to specify the maximum number of rows that are returned in a search result.

Answer 20

LIMIT

Question 21

What is the max value that can be set in a LIMIT clause?

Answer 21

The maximum value that can be set in a LIMIT clause is 2,000. The default limit is also 2,000

Question 22

Can a LIMIT clause be applied to individual objects in a single SOSL query?

Answer 22

Yes

Question 23

What happens when a limit is set on the entire query?

Answer 23

The results are evenly distributed among the objects returned.

Question 24

SOSL Limit Example:

Answer 24

FIND {test} RETURNING Account (Id LIMIT10)

Question 25

What does using Order By allow us to do in a SOSL query?

Answer 25

It allows us to specify the order of the results returned.

Question 26

Null records can be ordered at the beginning(default) or end by using ______________________

Answer 26

NULLS FIRST or NULLS LAST

Question 27

How can results be ordered in ascending or descending order? What is the Default order?

Answer 27

Asc/Desc, Ascending

Question 28

SOSL Order By Example:

Answer 28

FIND {test} RETURNING Account (Id, Name, Rating, Type ORDERBY Id DESC)

Question 29

What are wildcard characters used for?

Answer 29

Wildcard characters can be used to search values that match text patterns

Question 30

__________ can be used to match only one character in the middle or end of search term.

Answer 30

Question marks(?)

Question 31

____________ can be used to match zero or more characters in the middle or end of search term.

Answer 31

Asterisks (*)

Question 32

SOSL Wildcard Example:

Answer 32

The query FIND {Mi*}, will return results like “Mike” and “Michael OR FIND {United*} IN ALL FIELDS RETURNING Account(Id, Name), Contact(ID, Name)

Question 33

If we use SOSL to return a list of accounts, how can you retrieve an item from the list of a specific index value?

Answer 33

[0] where 0 is the specific index you are looking for.

Question 34

If we want to provide our SOSL query as a string and then supply that to a method to execute the SOSL in the string, what method would we use?

Answer 34

Use the query() method of the Search class and supply the string like so: List> results = Search.query(q); Where q is a string that represents our SOSL query.