Formatting multi-value variables

Interpolating a variable with multiple values selected is tricky as it is not straight forward how to format the multiple values into a string that is valid in the given context where the variable is used. SmartCollect SC² tries to solve this by allowing each data source plugin to inform the templating interpolation engine what format to use for multiple values.

Note: The Custom all value option on the variable must be blank for SmartCollect SC² to format all values into a single string. If leave it blank, then the SmartCollect SC² concatenates (adds together) all the values in the query. Something like value1,value2,value3. If a custom all value is used, then instead the value will be something like * or all.

Automatic escaping and formatting can cause problems and it can be tricky to grasp the logic behind it.

If you do not want SmartCollect SC² to do this automatic regex escaping and formatting, then you must do one of the following:

• Turn off the Multi-value or Include All option options.
• Use the raw variable format.