...
- Only simple fields will work; spaces or special characters (including $) can not be in the field name unless they are treated as a string, such as
$['Home address']. - To use a parameter in a SQL select statement, you can use a Mapper Snap before the SQL Snap to turn the parameter into an input field, which can then be used in the where clause using the $param syntax.
...