The WorkflowActions Tables
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
The workflow actions table is used to specify workflow settings that affect how the workflow events are exposed and function in the user interface.
The following table is an example of the workflow actions table schema.
| Column | Data type | Description |
|---|---|---|
| Id | identity (int) | Identifier for the user interface action. |
| Caption | nvarchar(128) | The text displayed in the user interface for this action. |
| Position | int | An integer that defines the order of the actions displayed in the user interface, working from the lowest number to the highest. Duplicate position values are permitted, but there is no guarantee of order within the duplicate values. |
| Enabled_Columns | ntext | Specifies which fields on the detail form are enabled for editing when this action is executed. It is a comma-separated list of fields. |
| Hidden_Columns | ntext | Specifies which fields on the detail form are hidden on the detail form when this action is executed. It is a comma-separated list of fields. |
| WorkflowId | int | Specifies the workflow associated with this action. |
| rowguid | uniqueidentifier | Unique identifier used for actions associated with workflow. |
See Also
Workflow-Enabled Database Tables | The modColumns Table | The modObjects Table | The modObjectTypes Table | The modPermissions Table | The modProperties Table (Workflow-Enabled Database) | The modUserRoles Table | The Workflow Tables | The Lookup Table