Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameactionflow
nopaneltrue


Excerpt
This page provides details of the properties for the

Bulk Update Node

.

Properties

Overview

Image Removed

Image Added

Use a

Insert excerpt
_action_bulkupdate
_action_bulkupdate
nopaneltrue
 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

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

    Worked Example

    For full details on how to create Bulk Update actions, including worked examples, see Bulk Update Action Configuration.

    Insert excerpt
    _property_tabs
    _property_tabs
    namebasic-h
    nopaneltrue

    Insert excerpt
    _parent
    _parent
    nopaneltrue

    Basic Settings

    FieldDescription
    NameEnter 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

    FieldDescription
    Data Range
    • Latest, selects data from the latest recordsets.
    • All, selects data from all recordsets (default).
    Filter CriteriaSpecifies the criteria by which the records will be selected. See Filter → Filter Details

    Filter Parameters

    The 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 Image Modified 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 Image Modified Delete.

    The Filter Types are mapped to using the incoming connection.


    Insert excerpt
    _description
    _description
    nopaneltrue

    Advanced Settings

    FieldDescription
    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.


    Insert excerpt
    _audit
    _audit
    nopaneltrue

    Live Search
    spaceKey@self
    additionalnone
    placeholderSearch all help pages
    typepage

    Panel
    borderColor#00374F
    titleColorwhite
    titleBGColor#00374F
    borderStylesolid
    titleSections on this page

    Table of Contents
    maxLevel3
    indent12px
    stylenone

    Learn More

  • Actionflows
  • Actionflow Courses