Sometimes, you want to skip a field mapping when running a message. You can use conditions to indicate whether the field mapping must be applied. The field mapping is only applied if the conditions are met. You can set up several conditions for each field mapping.
Examples of values you can use to define a condition:
Value | Description |
..Item1 | Item1 and smaller |
Item1.. | Item1 and greater |
Item1,item5..item10 | Item1 or item5 till item10 |
Item1,item2 | Item1 or item2 |
!123 | Not 123 |
“” | Empty |
!”” | Not empty |
curExt() | Used to apply a condition with the current company |
Steps
Click Connectivity studio - Integration Design.
On the Message tab, in the list, find and select the desired message.
Click Edit.
In the Mapping section, in the Target record list, find and select the desired record.
On the Mapping tab, on the Field mapping tab, in the list, find and select the desired field mapping.
In the Use condition field, select 'Yes'.
Click the Field condition tab.
Define whether the condition is based on a field in the source document or the target document.
In the Record origin field, select an option.
Define the document record of the field on which the condition is based.
In the Source field, enter or select a value.
Define the document record field on which the condition is based.
In the Field field, enter or select a value.
Define the condition value.
In the Value field, type a value.
Note
You can configure mapping condition values without field length restrictions.
Sub-task: Set additional conditions.
Usually, you use only one condition defined in the fields above the grid. You can, however, define additional conditions. Enter the additional conditions in the grid.
Click New.
Define whether the condition is based on a field in the source document or the target document.
In the Record origin field, select an option.
Define the document record of the field on which the condition is based.
In the Record field, enter or select a value.
Define the document record field on which the condition is based.
In the Record field field, enter or select a value.
Define the condition value.
In the Value field, type a value.
Note
You can configure mapping condition values without field length restrictions.
Close the page.
Note
Applying conditions can affect message performance. Therefore, apply a condition only if required and keep it as simple as possible.