Bulk Update Node Properties Image Removed Image Added
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 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 Properties. |
Worked ExampleFor full details on how to create Bulk Update actions, including worked examples, see Bulk Update Action Configuration. | 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 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. |
|