SOQL and SOSL Reference

Introduction to SOQL and SOSL
Salesforce Object Query Language (SOQL)
Salesforce Object Search Language (SOSL)
Typographical Conventions in This Document
SOSL Limits on Search Results
SOSL Limits on External Object Search Results
SOSL Syntax
Example Text Searches
convertCurrency()
FIND {SearchQuery}
FORMAT()
IN SearchGroup
LIMIT n
OFFSET n
ORDER BY Clause
RETURNING FieldSpec
toLabel(fields)
Update an Article’s Keyword Tracking with SOSL
Update an Article’s Viewstat with SOSL
USING Listview=
WHERE
WITH DATA CATEGORY DataCategorySpec
WITH DivisionFilter
WITH HIGHLIGHT
WITH METADATA
WITH NETWORK NetworkIdSpec
WITH PricebookId
WITH SNIPPET
WITH SPELL_CORRECTION
PDF

toLabel(fields)

Use toLabel(fields) to translate SOSL query results into the user’s language.

Any organization can use the toLabel() method. It’s particularly useful for organizations that enabled the Translation Workbench. 

1toLabel(object.field)

For example:

1FIND {Joe} RETURNING Lead(company, toLabel(Recordtype.Name))

The returned records are translated into the language of the user who issued the query.

You can’t filter on the translated name value from a record type. Always filter on the master value or the ID of the object for record types.

Note

You can use the toLabel() method to filter records using a translated picklist value. For example:

1FIND {test} RETURNING Lead(company, toLabel(Status) WHERE toLabel(Status) = 'le Draft' )

The query returns lead records with a picklist value for Status equal to 'le Draft.' The comparison is made against the value for the user’s language. If no translation is available for the picklist, the comparison is made against the master values.

The toLabel() method cannot be used with the ORDER BY Clause. Salesforce always uses the order defined in the picklist, just like reports.

Note

The toLabel function supports aliasing. In addition, aliasing is required when the query includes the same field multiple times. For example:
1FIND {Joe} RETURNING Lead(company, toLabel(Recordtype.Name) AliasName)