| Info |
|---|
...
| title | Note |
|---|
Roll Up in Single Row mode is only available in environments 13.x or higher. Roll Up in Batch mode is fully supported. |
The Single row Upsert mode is used for loading a single row into the database if the warehouseTransaction/batchKey element is not present or null in the incoming EagleML message. The message contains a logical unique Object key for each Warehouse Open Lot object instead of the warehouseTransaction/batchKey element.
For the Upsert mode, the warehouseTransaction node can contain only one warehouseOpenLot complex element.
Upsert mode available examples:
| Child pages (Children Display) |
|---|
Procedure Mode Element
The mode: INSERT or UPDATE can be defined automatically or by the element Procedure Mode.
...
For loading the new row into the database the value of element Procedure Mode should be null or equal ‘INSERT’ if the row does not exist in the database tables:
| Code Block | ||
|---|---|---|
| ||
<procedureMode>INSERT</procedureMode> |
See the example of incoming EagleML message for inserting new record in the Upsert Mode.
Update Data
For updating the existing row in the database the value of element Procedure Mode should be null or equal ‘UPDATE’ if the row exists in the database table:
| Code Block | ||
|---|---|---|
| ||
<procedureMode>UPDATE</procedureMode> |
See the example of incoming EagleML message for updating record in the Upsert Mode.
After inserting or updating the record, Roll up will will always run.