Parameters Object

The parameters object contains parameter values that are passed to the workflow rule from the client.

Expression	Description
${parameters[name]}	Returns parameter value formatted for SQL query

For all parameters used in binding expressions you must declare parameter name and data type, and can also specify a default value which will be used if the client does not send a value.

ds.addParameter("status", "Requested", DataSource.DATA_TYPE_TEXT);

Date startDate = ...;
ds.addParameter("startDate", startDate, DataSource.DATA_TYPE_DATE);

Parameter values are formatted for SQL according to their data type. The parameter data types are the same as virtual field data types, plus DataSource.DATA_TYPE_VERBATIM – parameters of this type are inserted into SQL verbatim, without any formatting.

ds.addParameter("subquery", "", DataSource.DATA_TYPE_VERBATIM);
ds.addQuery("SELECT ... FROM ... WHERE EXISTS ${parameters['subquery']}", DataSource.DIALECT_GENERIC);