Configuring the Search Objects activity
You must create an Sforce Object Search Language (SOSL) query to configure the Search Objects activity.
About this task
The following sections discuss the steps to configure the Search Objects activity, create an SOSL query, and provide SOSL syntax rules for IBM® Cast Iron®.
To configure the Search Objects activity complete the following steps:Procedure
Creating SOSL queries
About this task
When creating a Sforce Object Search Language (SOSL) query, you can use dynamic parameters in the WHERE clause of the SOSL statement. Studio can then dynamically map these parameters as the input parameters for the activity. This allows for dynamic control of the query that is based on input to the orchestration.
The Sforce Object Search Language does not define a syntax for parameterized queries; however, IBM Cast Iron does enforce a few proprietary SOSL syntax rules. You can use parameters in either simple expressions or set expressions.
SOSL syntax rules for IBM Cast Iron
About this task
- Use a ($) dollar sign to denote a parameter. After the ($) dollar
sign, specify a string of alphanumeric characters. The first character
must be a letter [a-zA-Z], optionally followed by one or more letters
[a-zA-Z], digits [0-9], or ( _ ) underscores. Note: Parameter names are case-sensitive; therefore, the parameters $a and $A are considered to be different parameters.The following table contains examples of valid and invalid parameter declarations:
Parameter Valid or Invalid $AnAccount valid $a123_456 valid $123a invalid $_id invalid
- You must declare parameters in the Search Query portion of the
SOSL statement. Curly braces ({ }) demarcate
the Search Query portion of the SOSL statement. Important: Do not use double quotation marks (" ") to enclose parameters. If you enclose parameters in double quotation marks, the activity treats the parameter as a string search literal.
- The parameter type is always xsd:string. During substitution,
the activity escapes any parameter that you declare using a reserved
character. Reserved characters include the following characters:
Reserved Characters Description & ampersand * asterisk \ back slash [ ] box brackets : colon , comma { } curly braces " Double quotation mark ! exclamation mark - minus sign + plus sign ' Single quotation mark ~ tilde ^ up arrow | vertical bar - Parameters can appear more than once in a given SOQL statement. However, even though the parameter appears more than once in the SOQL statement, it only appears once in the input parameter map. The activity substitutes the same value for all locations where the parameter is used at run time.