Table of Contents

Search

  1. Preface
  2. Understanding Data Types and Field Properties
  3. Designing Processes
  4. Using and Displaying Data
  5. Designing Guides
  6. Designing Process Objects
  7. Designing Service Connectors
  8. Using Connectors
  9. System Services, Listeners and Connectors

2. Design

2. Design

Setting Source Values: Formula

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 "
    x
    " prefix.
  • If
    $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).


Updated February 11, 2021