Some content on this site is available only to logged-in subscribers. Contact Us for information on becoming a subscriber.

InSource.Solutions | InSource Training | InSource Client Portal
InSource Solutions Logo
Log In Sign Up
InSource.Solutions InSource Training InSource Client Portal Log In Sign Up
  • Home
  • AVEVA Work Tasks [fka Skelta]
  • AVEVA Work Tasks Tech Notes

TN 1269 Work Tasks - Updating Form Information Using SQL Stored Procedure

Last updated: March 5th, 2025

Description

  • Author: Devin Hepburn
  • Published: March 5th, 2025

Details:

Description

This article from InSource shows...

  • Author: Devin Hepburn
  • Published: 06/23/2022
  • Applies to: AVEVA Work Tasks / Skelta BPM

Details

Forms in Work Tasks will often connect with SQL Databases. For repeat procedures, it is beneficial to generate a Store Procedure to handle those transactions. This example will show how to interface with those store procedures and return information to the form dynamically.

  1. Store Procedure Generation:
  • This simple stored procedure accepts two parameters (@in1 and @in2). It adds those together and returns the sum of those two numbers as an output. Our goal for this exercise will be ingesting those two numbers VIA a Work Tasks form and update another box with the output.
  1. Create workflow
  • We will create a workflow that maps inputs from the form to variables within the workflow. It will then pass those into the store procedure as inputs and store the returned integer into a variable that be passed back into the form.
    • Create Input XML Variables
  • Create workflow
  • Set the variable SCHEMA for stored procedure.
  • Configure the BlockingOutput that will be used to pass data back into the form. Notice here that the XML Variable "Sum" that was created in the previous step has a table/column selection due to the way the Stored Procedure feeds the information back into Work Tasks. We will be selecting the only column here for this example.
  1. Create Form
  • This form will invoke the workflow we just created after the two inputs have been populated. The returned value will be passed into the third numerical control.
    • Add Controls. This example has 3 numerical controls and 1 control to invoke the workflow.
    • Configure InvokeWorkflow Control. Here, we will select the workflow that we just created and the input XML variable that we generated in the start properties of that XML. This will allow us to map our form variables to the workflow variables.
    • Configure workflow XML Mapping.
    • Script for Post Workflow Execution. This will allow us to update the third numerical control with the BlockingOutput of the workflow.
      • Click on Post-Workflow Execution to Edit Script. Use the following.
sql procedure form update
Give feedback about this article

Recommended articles

TN IT166 How to create a sound for an alarm in InTouch

Read More

TN IT212 Display Rich Text Format (RTF) Inside Intouch

Read More

TN IT198 Automatic logout (Inactivity Warning and Timeout)

Read More
Support Icon

CONTACT SUPPORT

How to reach us

10800 Midlothian Turnpike Tpke, Suite 209, Richmond, VA 23235

1.877.INSOURCE

Technical Support - 1.888.691.3858

Contact Us

  • InSource Solutions
  • InSource Training
  • InSource Client Portal
  • Log In
InSource Solutions Logo

© 2025 InSource Solutions. All Rights Reserved.

Knowledge Base Software powered by Helpjuice

Expand