Update - Update a Record In a Database

This is a component to perform update operation on the set of the data source in the process.

Example: Update the values of Temperature and Humidity for the given Device ID.

Steps:

  1. Click + under Database Operations to create a database operation.

  2. Enter the name of the operation and select Type as Update.

  3. Click OK. A new component is created and displayed in the designer.
    Image 1

  4. Click Edit in the top menu to open the Properties Panel.

  5. Navigate to Properties > Data Source and select the required data source. You can create a new data source such as SQL Data Source under Settings.

  6. Click Properties > Instruction to open the editor and write the Update SQL Instruction.
    Image 2

  7. Write down the SQL Instruction in the editor and click OK.
    Image 3

  8. Alternatively, you can leave the instruction field blank and select an Entity in the Properties > Entity field.
    This generates the update SQL based on the entity schema automatically.
    The input parameters are strongly typed to the target table, such as the names of the parameters must match the field Resource IDs in the entity schema.

  9. Click SAVE to save the configuration.
    Image 4