Sign in
Development questions

Write a SOSL query to search for the string 'Universal' across Account, Contact, and Lead returning specific fields from each object (FIND 'Universal*' IN ALL FIELDS RETURNING Account(Id, Name), Contact(Id, LastName, Email), Lead(Id, Company)).

DevelopmentMediumInfosysWiproTCSAccenture

SOSL searches text across multiple objects and returns a list of lists, one per object in the RETURNING clause.

apex
List<List<SObject>> results = [FIND 'Universal*' IN ALL FIELDS
    RETURNING Account(Id, Name), Contact(Id, LastName, Email), Lead(Id, Company)];
List<Account> accs = (List<Account>) results[0];
List<Contact> cons = (List<Contact>) results[1];
List<Lead> leads = (List<Lead>) results[2];

The * is a wildcard; use IN NAME FIELDS to limit the search scope.

soslscenariosearch

More Development questions