The Data Retriever applet cannot run all available SOQL functions, and certain limits are in place. To use SOQL in the Data Retriever applet, you must take into account the following information.
LIMIT clause
You must use the LIMIT clause in all SOQL queries to specify the maximum number of records that you expect your query to return. The exception to this rule is if your query contains only aggregate functions. This enables the Data Retriever to prepare the data sources that store the returned values.
...
You can specify a maximum of 10 in the LIMIT clause for performance reasons.
Field names and labels
In the SOQL query, refer to fields and objects using their names or API names as they appear in Salesforce. The resulting data sources use the corresponding labels for those fields and objects. For example, use NVMContactWorld__ACD__c in the SOQL query to return the value of the ACD field on a task (task) record. The corresponding data source is named Task|ACD.
Existing data sources and custom configuration settings in the query
You can include one or more placeholders in your SOQL query. The Data Retriever applet replaces the placeholders with data source values or custom configuration settings retrieved at run time.
...
| Info | ||
|---|---|---|
| ||
If you want to match a data source against a Salesforce field that contains non-numeric characters, inserts the data source placeholder between single quotes ('). For example, If the Salesforce field contains a numeric value, do not use single quotes. For example, |
Unsupported SOQL clauses
You cannot currently use the following clauses:
...
Date aggregate functions are also not supported.
Highlighting and autocomplete
- The SOQL Editor highlights keywords (such as
SELECT,LIMIT,FROM, and so on) in your query as you type. - The SOQL Editor autocompletes data sources and custom configuration settings as you type. For example, if you type
$or#a list of available data sources or custom configuration keys appears. - The SOQL Editor accepts standard key combinations, such as Ctrl+A, Ctrl+C, Ctrl+X, Ctrl+V, Ctrl+Z, Ctrl+Y. Ctrl+D deletes a line in SOQL Editor.
Created data sources
When you save a Data Retriever containing a SOQL query, a list of the data sources created by the applet appears.
...