Design

Back Next

Setting Source Values: Formula

Fields that take numeric input fields can use a formula to set a value. For example, you can use this with the Assignment step to add a number to an existing field. Use numeric operators such as +, -, *, div, and mod to perform an operation upon fields.

You can also use any XQuery function within a formula. (These are defined at http://www.w3.org/TR/xpath-functions-30/.)

Evaluation Notes

Process Designer evaluates formulas as you might expect. Note that:

$Field1.Field2.Field3

is pre-processed to de-reference down to the contents of

Field3

and would bind the contents to its value.

Special characters in field names are removed. Fields that start with numbers are given an "

" prefix.

$Account

is a by-value object, you must use an XPath path expression to get at its contents; for example,

$Account/Owner/Name

Object lists should be sequences containing either ID values (for by-reference object lists) or the XML representation of the records. For example, two object lists can be appended using the following expression:

($a,$b)

Object references within a list are separated by semi-colons; for example,

(a; b; c)

For information on available functions, see Functions (Process Designer).

Setting Source Values

Download Guide

Watch

Comments

Cloud Application Integration Homepage

Free Trial

Communities

Knowledge Base