Data Status

Data Status is a regular block that tracks the status of read, lookup, add, update and delete operations for a database table.

The block consists of the following (from top to bottom):

• Operation: Dropdown configuration setting to select the specific database operation you want to track the status of. The dropdown options are:

  1. Read - Tracks the completion of database read operations by Data Read, Data Read Next and Data Read Previous blocks.

  2. Add - Tracks the completion of database add operation by the Data Add Record block.

  3. Update - Tracks the completion of database add operation by Data Update Record with ID and Data Update Records blocks.

  4. Delete - Tracks the completion of the database delete option by Data Delete Record with ID and Data Delete Records blocks.

  5. Lookup - Tracks the completion of the database lookup operation using the Data Lookup block.

• Table: Value Parameter that accepts a text value representing the name of the Database Table .

• Dataset Name: Value Parameter that accepts a text value representing the name of the dataset. This can be any text value and can later be used to track the completion of the read.

• Success Tasks: a Flow Parameter where you connect blocks that specify what you want done when the operation completes successfully.

• Failure Tasks: a Flow Parameter where you connect blocks that specify what you want done when the operation has an error.

Usage Examples

The example below shows the Data Status block being used to track the completion of a database read operation. This example is explained in more detail here.

The next example (below) shows the Data Status block being used to track a database add operation. This example is explained in more detail here.

The image below is our third example, where we use the Data Status block to track a database update operation. This example is explained in more detail here.