SOQL and SOSL Reference

Introduction to SOQL and SOSL
Salesforce Object Query Language (SOQL)
Typographical Conventions in This Document
Quoted String Escape Sequences
Reserved Characters
Alias Notation
SOQL SELECT Syntax
Condition Expression Syntax (WHERE Clause)
Using null in SOQL Queries
Translating Results
Filtering on Boolean Fields
Querying Multi-Select Picklists
Filtering on Polymorphic Relationship Fields
fieldExpression Syntax
USING SCOPE
ORDER BY
LIMIT
OFFSET
Update an Article’s Keyword Tracking with SOQL
Update an Article Viewstat with SOQL
WITH filteringExpression
GROUP BY
HAVING
TYPEOF
FORMAT ()
FOR VIEW
FOR REFERENCE
FOR UPDATE
Aggregate Functions
Date Functions
Querying Currency Fields in Multi-Currency Orgs
Example SELECT Clauses
Relationship Queries
Change the Batch Size in Queries
SOQL Limits on Objects
Syndication Feed SOQL and Mapping Syntax
Location-Based SOQL Queries
Async SOQL
Salesforce Object Search Language (SOSL)
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Translating Results

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

A client application can have results from a query returned that are translated into the user’s language, using toLabel():

1toLabel(object.field)
Any organization can use toLabel(). It is particularly useful for organizations that have the Translation Workbench enabled. Use toLabel() to return translations on:
  • Regular, multi-select, division, or currency code picklist fields that have values returned by the relevant describe call.
  • Data category group and data category unique name fields.
  • RecordType names.

Object history is supported on a limited basis. When a tracked field changes, SELECT toLabel(Field) FROM *History returns either the changed field’s master label or the translated label, if one exists. OldValue and NewValue fields in field history objects also support toLabel, but only tracked changes on supported field types return translated values.

Note

For example:

1SELECT Company, toLabel(Recordtype.Name) FROM Lead

This query returns lead records with the record type name translated into the language for 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 toLabel() to filter records using a translated picklist value. For example:

1SELECT Company, toLabel(Status)
2FROM Lead
3WHERE toLabel(Status) = 'le Draft'

Lead records are returned where the picklist value for Status is 'le Draft.' The comparison is made against the value for the user’s language. If no translation is available for the user’s language for the specified picklist, the comparison is made against the master values.

The toLabel() method can’t be used with ORDER BY. Salesforce always uses the picklist’s defined order, just like reports. Also, you can’t use toLabel() in the WHERE clause for division or currency ISO code picklists.

Note