Salesforce Menu

SOSL Examples

1. Query Account or Contact records which have the value ‘SalesforceDrillers’ in any field

FIND {SalesforceDrillers} IN ALL FIELDS  
RETURNING Account(Name), Contact(FirstName,LastName)

2. Query all the Accounts have any value starting from ‘Salesforce’ and the Accounts were also created in this month

FIND {Salesforce*} IN ALL FIELDS RETURNING Account(Name WHERE CreatedDate = THIS_MONTH)
Subscribe Now