The WorkflowActions Tables

See Also

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.