Use functions in SOQL queries to generate reports for analysis, apply localized formatting to standard and custom fields, group or filter data by date periods, and more.
| Functions | Description |
|---|---|
| Aggregate Functions | Use aggregate functions in a GROUP BY clause in SOQL queries to generate reports for analysis. |
convertCurrency() | Use convertCurrency() in SOQL queries to convert currency fields to the user’s currency. |
convertTimezone() | Use convertTimezone() in a date function of SOQL queries to convert dateTime fields to the user’s time zone. |
| Date Functions | Use date functions in SOQL queries to group or filter data by date periods such as day, calendar month, or fiscal year. |
FORMAT() | Use FORMAT() in SOQL queries to apply localized formatting to standard and custom number, date, time, and currency fields. |
GROUPING(fieldName) | Use GROUPING(fieldName) in SOQL queries to identify subtotals. |
toLabel() | Use toLabel() to translate SOQL query results into the language of the user who submits the query. |
j
