Server-Side Bindings - Data Source Properties

Expressions defined in the data source are evaluated on the server, using the server-side evaluation context that includes the following objects:

• user : includes all properties of the current user account, as well as properties of the employee record associated with the user.
• sql : object that can format date, time, and timestamp values according to the current database and/or current date and time
• parameters : provides access to all input parameters of the workflow rule that evaluates the expression (typically this is a standard workflow rule, but the client-side UI controls can pass arbitrary additional parameters to standard workflow rules).

Available expressions are limited to those specified in WEB-INF/config/context/core/core-optional.xml  in the ognlInjectionHandler bean.

This list does not include all supported expressions out of the box, but is restricted to those in use.  You can enable access to a supported expression by adding it to the list, e.g adding <value>user.employee.honorific</value> will give access to the ${user.employee.honorific} expression.

<clause name="wr.date_est_complete" op="&lt;=" value="${sql.currentDate}"/>

<sql>SELECT...FROM...WHERE wr.requestor = ${user.employee.id}</sql>

<sql>SELECT...FROM...WHERE wr.date_requested = ${sql.date('2007-01-01')}</sql>

<sql>SELECT...FROM...WHERE wr.status IN ${parameters['status_codes']}</sql>