The workflow actions table is used to specify workflow settings that affect how the workflow actions 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. |
WorklowId | int | Specifies the workflow associated with this action. Multiple actions in the workflow actions table can be associated with the same workflow row in the Workflow table. For example, one OnUpdate workflow event could be associated with two workflow actions, such as Edit and Assign, but each action would enable different fields for modification on the detail form. |
rowguid | uniqueidentifier | Unique identifier used for actions associated with workflow. |