Define a Data Model Table Query

You need to define several parameters in the table query you are adding to a form's data model.

Parameter
Description
Table Query Parameters
Workflow Type
  • Current Workflow: select a table from the current workflow.
  • External Table: select any table from a different workflow or from outside Sequence. Sequence cannot modify the structure of external tables.
  • New: define a new table.
Selected Table
The selected table's UACT name in the Sequence database.
Name
Define the query name of the table in the data model.
Key Name
Enter the table's primary key.
Secondary Key
Enter the table's secondary key. This is only relevant for Task Activities that have action items for recipients.
If the activity is a task, you can use the secondary key to better control the data.
Connection String
Enter the connection string to the table. This is only relevant for external tables.

The table below indicates the database operations that Sequence can perform on UACT and external tables.

Action/Table and Key
UACT - System Key
UACT - Any Key
UACT - No Key
External Table -
 Any Key
External Table -
No Key
Supported Database Operations
Select
V
Must supply key value
V
V
V
Insert
V
Key from UI
V
Key from UI
V
Update Single
V
Key from UI
V
Key from UI
V
Update Multiple
Has incremental key defined
  • UI should provide the Key
  • Has incremental key defined
Has incremental key defined
Has incremental key defined
Has incremental key defined
Delete
V
X
X
X
X
About this Article
  • Created: 05/16/2017 8:50 am EDT
  • Last updated: 05/17/2017 1:46 am EDT
In This Article