TestSets View

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

Description

Contains detailed information on test sets.

Dependencies

Columns

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.

AllowRun  :  varchar (max 1 char), allows null: no

Indicates whether the test set can be run.

AssignedToName  :  varchar (max 78 chars), allows null: yes

The name of the user to whom the associated item is assigned, in the Last name, First name format.

AssigneeUserId  :  int, allows null: yes

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

AvgRunTime  :  int, allows null: yes

The test set’s average run time, in seconds.

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

The test set’s average run time, in the hh:mm:ss format.

CreateUserId  :  int, allows null: no

The ID of the user who created the item.

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.

DateLastEscalated  :  datetime, allows null: yes

The date when the associated item was last affected by an escalation rule.

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 Text Feature.

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 Validations Table 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.

FolderName  :  varchar (max 511 chars), allows null: yes

The name of the folder where the associated 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.

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

The name of the escalation rule that last affected the associated item.

LastEscalationRuleId  :  int, allows null: yes

The ID of the escalation rule that last affected the associated item.

LastRunByUserId  :  int, allows null: yes

The ID of the user who last ran the test set.

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

The name of the user who last ran the test, in the Last name, First name format.

LastRunDate  :  datetime, allows null: yes

The date and time when the test set was last run.

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

LastRunReleaseId  :  int, allows null: yes

The ID of the release that was last used in the test set.

LastRunReleaseName  :  varchar (max 255 chars), allows null: yes

The name of the release that was last used in the test set.

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

The status of the last test set run.

NbrEscalations  :  int, allows null: no

The number of times an escalation rule affected the test set.

NbrEvents  :  int, allows null: no

The number of events attached to the test set.

NbrFiles  :  int, allows null: no

The number of files attached to the test set.

NbrFilesNotSecured  :  int, allows null: no

The column is reserved for system use only.

NbrNotes  :  int, allows null: no

The number of notes attached to the test set.

NbrSchedules  :  int, allows null: yes

The number of the related test schedules.

NbrTests  :  int, allows null: no

The number of tests in the test set.

NbrTimesRun  :  int, allows null: no

The number of times the test set was run.

NotesDescription  :  varchar (max), allows null: yes

An alias for the LatestNotes column of the ExtendedAttributes table.

A description of the latest note attached to the associated item.

OriginalId  :  int, allows null: yes

The column is reserved for system use only.

OwnerName  :  varchar (max 78 chars), allows null: yes

The name of the user who owns the associated item, in the Last name, First name format.

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 Validations Table table. They correspond to the items whose values equal TestSetPriority in the ValidationType column.

ProjId  :  int, allows null: no

The ID of the project that contains the item.

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 Validations Table table. They correspond to the items whose values equal TestSetStatus in the ValidationType column.

TestSetId  :  int, allows null: no

The unique numeric identifier of the test set.

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.

UserName  :  varchar (max 78 chars), allows null: yes

The name of the user who last updated the associated item, in the Last name, First name format.

See Also

Tests View
Test Management

Highlight search results