TestSets Table

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

Description

The table stores test sets. Test sets consist of multiple tests listed in the Tests table.

Columns

The table contains the following columns:

TestSetId  :  int, primary key, allows null: no

The unique numeric identifier of the test set.

ProjId  :  int, allows null: no

The ID of the project that contains the item.

ActFinish  :  datetime, allows null: yes

The column is reserved for system use only.

ActHrs  :  decimal (max 18 decimal digits), allows null: yes

The column is reserved for system use only.

ActStart  :  datetime, allows null: yes

The column is reserved for system use only.

AssigneeUserId  :  int, allows null: yes

The ID of the user to whom the test set is assigned.

CreateUserId  :  int, allows null: no

The ID of the user who created the item.

Custom1..Cistom10  :  nvarchar (max), allows null: yes

The values of custom fields 1 - 10.

These columns correspond to fields that can be available for rich editing.

DateCreated  :  datetime, allows null: no

The date and time when the test set 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.

Description  :  nvarchar (max), allows null: yes

The description of the test set.

This column corresponds to a field that can be available for rich editing.

EstFinish  :  datetime, allows null: yes

The column is reserved for system use only.

EstHrs  :  decimal (max 18 decimal digits), allows null: yes

The column is reserved for system use only.

EstHrsRemaining  :  decimal (max 18 decimal digits), allows null: yes

The column is reserved for system use only.

EstStart  :  datetime, allows null: yes

The column is reserved for system use only.

ExecutionType  :  nvarchar (max 100 chars, or 202 bytes), allows null: no

The type of the test set based on the choice list. The values of this choice list are stored in the Validation table. They correspond to the items whose values equal TestSetExecutionType in the ValidationType column.

FolderId  :  int, allows null: yes

The ID of the folder where the item is located.

ImportId  :  int, allows null: yes

This column is not used.

IsActive  :  nvarchar (max 1 char, or 4 bytes), allows null: no

Indicates whether the test set is active.

IsSequential  :  nvarchar (max 1 char, or 4 bytes), allows null: no

Indicates whether the tests in the test set must be run in the specified order.

OriginalId  :  int, allows null: yes

The column is reserved for system use only.

OwnerUserId  :  int, allows null: no

The ID of the user who owns the test set.

PctComplete  :  tinyint, allows null: yes

The column is reserved for system use only.

PriorityCode  :  nvarchar (max 100 chars, or 202 bytes), allows null: yes

The priority of the test set based on the choice list. The values of this choice list are stored in the Validation table. They correspond to the items whose values equal TestSetPriority in the ValidationType column.

StatusCode  :  nvarchar (max 100 chars, or 202 bytes), allows null: no

The status of the test set based on the choice list. The values of this choice list are stored in the Validation table. They correspond to the items whose values equal TestSetStatus in the ValidationType column.

Title  :  nvarchar (max 255 chars, or 512 bytes), allows null: no

The title of the test set.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

Tests Table
Tests View
Test Management

Highlight search results