Data Insert Activity Overview

v8.2 and earlier

Context

Use the Data Insert Activity to insert data from a dynamic workflow to either a Sequence database or external database. 

Use Cases

  • Combine data from various sources to display the data to users in a grid.
  • Display an action that happened in the flow and track it, extending beyond the one-to-one interaction with the user.

Wizard Tips

  • If you do not need a source query, then in the Data Insert Definition screen, enter any number in the Source Query text box. For example, enter 1.
  • If you need a source query:
    • Enter a query to use for copying the data.
    • In the Value column, use the ds object to quickly access the fields in the source query. For example, ds.Item["Field1"].
  • When the insert value is not taken from activity data, the system assumes the field type is the default type. For example, 35 is translated to type Int32. If you want to use a different type, for example Int16, you must use an explicit cast, such as ToInt16(35)
  • To insert a GUID, use one of these expressions: 
    • ToGuid("xxx-xx-...")
    • new GUID("xxx-xx-...")
  • To insert a manual date use the expression: ToDateTime("dd-mm-yyyy")

v8.3

Context

Use the Data Insert Activity to insert data from a dynamic workflow to either a Sequence database or external database. 

If the activity fails to calculate the expression for the data source, a null value is returned. The activity does not fail, and no compensation is triggered.

Use Cases

  • Combine data from various sources to display the data to users in a grid.
  • Display an action that happened in the flow and track it, extending beyond the one-to-one interaction with the user.

Wizard Tips

  • If you do not need a source query, then in the Data Insert Definition screen, enter any number in the Source Query text box. For example, enter 1.
  • If you need a source query:
    • Enter a query to use for copying the data.
    • In the Value column, use the ds object to quickly access the fields in the source query. For example, ds.Item["Field1"].
  • When the insert value is not taken from activity data, the system assumes the field type is the default type. For example, 35 is translated to type Int32. If you want to use a different type, for example Int16, you must use an explicit cast, such as ToInt16(35)
  • To insert a GUID, use one of these expressions: 
    • ToGuid("xxx-xx-...")
    • new GUID("xxx-xx-...")
  • To insert a manual date use the expression: ToDateTime("dd-mm-yyyy")