This page provides details of the properties for the Bulk Update Node. Overview
Use a | Insert excerpt |
|---|
| _action_bulkupdate |
|---|
| _action_bulkupdate |
|---|
| nopanel | true |
|---|
|
node to bulk update records (including saving new records) to a table. The Bulk Update node will update all records which satisfy the specified filter criteria set on the node. The node will only update records from a table with a Type of Transactional. Period of Transactional. | Warning |
|---|
The Bulk Update node will not update the audit history on a table (i.e. Audit Manual Changes has been enabled). To persist the audit history of the records, see Save Node. |
Setup- When creating a Bulk Update by default Tables with Audit Manual Changes enabled will not be shown in the available list.
- Enable Allow Audit Table to display Tables with Audit Manual Changes enabled.
| Insert excerpt |
|---|
| _property_tabs |
|---|
| _property_tabs |
|---|
| name | basic-h |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _parent |
|---|
| _parent |
|---|
| nopanel | true |
|---|
|
Basic Settings| Field | Description |
|---|
| Name | Enter the name for the action node. | | Table | The table in which the records will be updated. This table must have a Period of Transactional. |
Data Retrieval Option| Field | Description |
|---|
| Data Range | - Latest, selects data from the latest recordsets.
- All, selects data from all recordsets (default).
| | Filter Criteria | Specifies the criteria by which the records will be selected. See Filter → Filter Details |
Filter ParametersThe grid contains a list of incoming attributes which can be referenced by the Data Retrieval Options using the notation ConnectorName.AttributeName e.g. in.MyAttribute. - To add a new Filter Parameter, in the section toolbar click
 Add New and set the properties. - To edit an existing Filter Parameter, double-click it in the list to open its properties.
- To remove a Filter Parameter, select one and in the section toolbar click
 Delete.
The Filter Types are mapped to using the incoming connection.
| Insert excerpt |
|---|
| _description |
|---|
| _description |
|---|
| nopanel | true |
|---|
|
Advanced Settings| Field | Description |
|---|
| Prioritise throughput over ordering | When this option is ticked records are |
processes processed in parallel to optimise performance. This means the order records are processed is nondeterministic. When unticked (default), records are processed in the order they are provided. |
|