my code stock.com

bansteatt84

Server-Side Bindings - Data Source Properties
by bansteatt84

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).

The following data source properties can contain binding expressions:

SQL query text
SQL restriction text (for restrictions defined in AXVW and restrictions sent from the client);
Parsed restriction values (for restrictions defined in AXVW and restrictions sent from the client
Default field values.
Binding expressions in data source properties are evaluated when a workflow rule is called (at request time, or when scheduled rule is executed).

Snippet options

Download: Download snippet as server-side-bindings-data-source-properties.txt.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

Examples:

The parsed restriction defined in the data source uses the current date: 

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

The SQL query defined in the data source includes the current user employee ID: 

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

The SQL query defined in the data source includes the date literal:

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

The SQL query defined in the data source includes the WFR parameter sent from the client: 

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

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.