You can use an expression to modify the value. In the expression, use source fields, target fields, or mapping variables as variables.
As a variable in the expression, you can use a:
Examples:
You can use an expression to:
Note:
| 1. | Click Connectivity studio Integration Design. |
| 2. | On the Message tab, in the list, find and select the desired message. |
| 3. | Click Edit. |
| 4. | In the Mapping section, in the Target record pane, in the list, find and select the desired target record. |
| 5. | On the Mapping tab, on the Field mapping tab, in the list, find and select the desired field mapping. |
| 6. | Click the Field options tab. |
| 7. | Select the Custom check box. |
| 8. | Add a variable line for each variable that is used in the expression. |
|   | In the Variables pane, click New. |
| 9. | In the Variable field, type exactly the variable name as used in the expression. |
| 10. | Define if the variable is linked to a field in the source document or target document. |
|   | In the Record origin field, select an option. |
| 11. | Define the document record to which the variable is linked. |
|   | In the Record field, enter or select a value. |
| 12. | Define the document record field to which the variable is linked. |
|   | In the Record field field, enter or select a value. |
|   |
Note: The field type, as defined for the document record field, is shown as well. |
| 13. | During a message run, you can use mapping variables to temporary store values. You can write (calculated) values to a mapping variable. Later, during the same message run, you read the value from the mapping variable for use in a custom expression. |
|   | In the Mapping variable field, enter or select the mapping variable which value is used in the expression. |
|   |
Note: Make sure, the field mapping in which the mapping variable is written, is done before the field mapping for which you define the custom expression. |
| 14. | You can indicate how the variable value must be handled in the expression, regardless of the document record field type. |
|   | In the Variable type field, select an option. |
| 15. | You can define the language in which the variable is expressed. |
|   | In the Language field, enter or select a value. |
| 16. | In the Expression field, enter the expression, using variables. |
| 17. | Before the output value of the custom option is determined, you can apply a type conversion to the value that is returned by the custom expression. |
|   | In the Type conversions field, enter or select a value. |
|   |
Note: You can test the created expression. To do so, click test expression. On the dialog, fill in the values of the variables and click Execute. |
| 18. | Close the page. |
Applying expression conditions can influence the message performance. So, only apply an expression condition if required and keep it as simple as possible.
| Related to | Notes |
|---|---|
|
Define field options |
  |