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. DranSCADA 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 DranSCADA to format all values into a single string. If leave it blank, then the DranSCADA concatenates (adds together) all the values in the query. Something like
value1,value2,value3
. If a customall
value is used, then instead the value will be something like*
orall
.
Automatic escaping and formatting can cause problems and it can be tricky to grasp the logic behind it.
If you do not want DranSCADA 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.