Execute Scalar - Execute Scalar SQL Query

This component executes a query returning a single value. Contineo supports Execute Scaler DB Operation to retrieve the single value from SQL Query. In this database Operation, you must write the SQL Instruction manually. This component executes the query and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

Example: To get average temperature value for the given device from the sensor data table.

Steps:

  1. Click + under DB Operations to create the new database operation.

  2. Enter the Name of the operation and select Type as ExecuteScalar.

  3. Click OK. The new component is created and opened in the designer.

    Step 3

  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 on Properties > Instruction to open the editor to write the Select SQL Instruction below the editor.

    Step 6

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

    Step 7

  8. Click SAVE to save the configuration.

    Step 8