What is a Bulk

Update Action?

Image RemovedImage Added

The 

Note: Bulk Delete Update actions will only delete update records in tables with the Period of Transactional.

Insert excerpt
_action_

save _action_

save nopanel true

 vs 

Insert excerpt
_action_

bulkupdate _action_

bulkupdate nopanel true

 

The key difference between 

To delete To update records and persist the audit history of the record, see Delete NodeSave Action Configuration.  

Creating Bulk

Update Actions

1. Click the 

   Insert excerpt
   _action_

   bulkdelete

   bulkupdate _action_

   bulkdelete

   bulkupdate nopanel true

    icon in the toolbar to display any existing tables in the application
   1. Existing tables can be dragged from the Repository onto the canvas, then choose 

      Insert excerpt
      _action_

      bulkdelete

      bulkupdate _action_

      bulkdelete

      bulkupdate nopanel true

       to create a Bulk Delete Bulk Update node
2. Alternatively, drag the 

   Insert excerpt
   _action_

   bulkdelete

   bulkupdate _action_

   bulkdelete

   bulkupdate nopanel true

    icon from the toolbar onto the canvas
3. In the Create Bulk Delete Bulk Update Action window:
   1. Enter a Name
   2. Choose a Type from: Delete: allows only records satisfying the specified filter criteria to be deletedSet the filter criteria in the Bulk Delete Action  Insert excerpt_property_settings_property_settingsnopaneltrue under Data Retrieval Options - see section below
   3. Delete All: deletes all data from the selected table 
   Choose to Allow Audited Table to display tables with Audit Manual Changes enabled in the Table drop down
   1. By default, tables with Audit Manual Changes enabled are not shown in the Table drop down list
   4. Choose the Table from the drop down where the records will be deletedupdated
      1. Or click the table icon to display tables in the Repository
   5. Select Create Action

When creating delete creating update actions it can be useful to set up confirmation messages that allow users to confirm or cancel the deletionupdate. See 1.13 Confirmation Message Configuration.

Setting

Update Action Filter Criteria

Where the Type is set to Delete on the Insert excerpt_action_bulkdelete_action_bulkdeletenopaneltrue action, the A filter must be set for the Bulk Update action to run. Set this in the Data Retrieval Options section shows in the of the  

1. Choose a Data Range from:
   1. Latest: selects data from the latest recordsets
   2. All: selects data from all recordsets (default)
2. Set the Filter Criteria to specify which records will be selected for deletionupdated. See Filter → Filter Details
   1. Incoming attributes mapped to the Bulk Delete node Update node can be referenced in the Data Retrieval Options using the syntax, ConnectorName.AttributeName, e.g. in.MyAttribute

Specify Delete Batch Size

Worked Example

Here's a worked example using the Company Data (available from the Learning Centre).

In this example, we are using:  

• A Company Rejected Companies screen containing three grids of the Companies, Management screen containing a grid of the Companies data and a card container of their associated Employees - this screen was created using the Multi-Tile template
• A Company Merger Pop up screen containing:
  • two manual drop down fields of the company name's of the companies to be merged
  • two string fields showing the company ID's of the companies to be merged
  • a button to initiate the Actionflow - this screen was created using the Tile no Buttons template
• A Company Orders screen containing two grids of the Orders and OrderLines data - this screen was created using the Multi-Tile template

Image Removed

Bulk Delete Rejected Companies

Actionflow Setup

These should contain filters so only the Orders and OrderLines for the companies with a Status of Rejected are mapped

Bulk Delete Action Setup

1. Create three Bulk Delete Actions for deleting from the three tables: Companies, Orders and OrderLines
2. Map the associated ID attribute into the relevant Bulk Delete node
3. Set up filters on each node in the Data Retrieval Options section to ensure only records associated with a rejected company are deleted

Testing

Testing

1. Close all screens and reopen the Company Management screen
2. Decide which two companies you will merge
   1. Make a note of their employees on the Company Management screen so you can see if the merge is successful
   2. Open the Company Orders screen and make a note of any Orders and Order Lines for the two companies
3. On the Company Management screen, click the Merge button to open the Company Merger Pop up screen
4. Select the two companies using the drop down fields and click the Run Acquisition button
5. Review the screens to check the merge was successful

Image Modified