Workflows Table

Applies to QAComplete 12.84 SaaS, last modified on July 19, 2021

Description

When defining a workflow, the status and transitions are stored in the Workflows table.

Columns

The table contains the following columns:

WorkflowId  :  int, primary key, allows null: no

The unique numeric identifier of the item.

ProjId  :  int, allows null: no

The ID of the project that contains the item.

AssigneeUserId  :  int, allows null: yes

The ID of the user to whom the item is automatically assigned when the specified status is reached.

DateCreated  :  datetime, allows null: no

The date and time when the item was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: no

The date and time when the item was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

FormName  :  varchar (max 30 chars), allows null: no

The name of the related module.

IsAllowed  :  char (max 1 char), allows null: no

Indicates whether the status can transition to a new status.

Status  :  varchar (max 100 chars), allows null: no

The initial status of the transition.

StatusTemporalTransition  :  varchar (max 100 chars), allows null: yes

The status the item transitions to if the current status is temporary.

StatusTransition  :  varchar (max 100 chars), allows null: no

The new status that it may transition to.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

Workflows View
Crossmodules

Highlight search results