TestSetItems View

Applies to QAComplete 12.75 SaaS, last modified on April 01, 2021

Description

Contains detailed information on tests of test sets.

Dependencies

Columns

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

An alias for the PersonName column of the Persons view.

The name of the user, in the Last name, First name format.

AssigneeUserId  :  int, allows null: yes

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

AvgRunTime  :  int, allows null: yes

The test’s average run time, in seconds.

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

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

CreateUserId  :  int, allows null: no

The ID of the user who created the item.

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

The values of custom fields 1 - 10.

These columns correspond to fields that can be available for Rich Text Feature.

Custom11..Custom90  :  varchar (max 100 chars), allows null: yes

The values of custom fields 11 through 90.

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.

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.

DefaultHostId  :  int, allows null: yes

The ID of the test host that is used as the default host for the test that is part of the test set.

DefaultHostName  :  nvarchar (max 2206 chars, or 4414 bytes), allows null: no

An alias for the Title column of the TestHosts view.

The title of the host, in the “<Host name> - <Operation system> - <Test Agent>” format.

Description  :  nvarchar (max), allows null: yes

The description of the test.

This column corresponds to a field that can be available for Rich Text Feature.

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

The type of the test run 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 TestExecutionType in the ValidationType column.

FolderId  :  int, allows null: yes

The ID of the folder where the test 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

The ID of the imported batch in which the test was imported.

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

Indicates whether the test is active in the test set.

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

Indicates whether the test is automated.

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

Indicates whether the test set execution stops when the test fails.

IsTokenized  :  nvarchar (max 1 char, or 4 bytes), allows null: no, default: N

Indicates whether the test uses token values.

IterationCnt  :  int, allows null: yes

If the test is tokenized, IterationCnt shows the total number of test iterations.

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.

LastRunByName  :  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.

LastRunByUserId  :  int, allows null: yes

The ID of the user who last ran the test.

LastRunDate  :  datetime, allows null: yes

The date and time when the test was last run.

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

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

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

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

The status of the last test run.

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

The name of the configuration used for the last test run.

LastRunTestSet  :  int, allows null: yes

The ID of the test set used for the last run.

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

The title of the test set used for the most recent run.

NbrEscalations  :  int, allows null: no

The number of times an escalation rule affected the test.

NbrEvents  :  int, allows null: no

The number of events attached to the test.

NbrFailStatus  :  int, allows null: yes

The number of times the test failed.

NbrFiles  :  int, allows null: no

The number of files attached to the test.

NbrFilesNotSecured  :  int, allows null: yes

The column is reserved for system use only.

NbrNotes  :  int, allows null: no

The number of notes attached to the test.

NbrPassStatus  :  int, allows null: yes

The number of times the test passed.

NbrSteps  :  int, allows null: yes

The number of steps in the test.

NbrTimesRun  :  int, allows null: yes

The number of times the test 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: yes

The ID of the user who owns the test.

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

The priority of the test 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 TestPriority in the ValidationType column.

ProjId  :  int, allows null: no

The ID of the project that contains the test.

ScriptName  :  nvarchar (max 255 chars, or 512 bytes), allows null: yes

The column is reserved for system use only.

ScriptSourceId  :  int, allows null: yes

The column is reserved for system use only.

Seq  :  int, allows null: no

The ordinal number of the test in the test set.

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

The status of the test 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 TestStatus in the ValidationType column.

TestCreateUserId  :  int, allows null: yes

An alias for the CreateUserId column of the Tests table.

The ID of the user who created the test.

TestDateCreated  :  datetime, allows null: no, default: Current date and time

An alias for the DateCreated column of the Tests table.

The date and time the test was created.

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

TestDateUpdated  :  datetime, allows null: no, default: Current date and time

An alias for the DateUpdated column of the Tests table.

The date and time the test was last updated.

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

TestId  :  int, allows null: no

The ID of the related test.

TestIsActive  :  nvarchar (max 1 char, or 4 bytes), allows null: no, default: Y

An alias for the IsActive column of the Tests table.

Indicates whether the test is active.

TestSetId  :  int, allows null: no

The ID of the related test set.

TestSetItemId  :  int, allows null: no

The unique numeric identifier of the item.

TestTokens  :  nvarchar (max 4000 chars, or 8002 bytes), allows null: yes

The column is reserved for system use only.

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

The type of the test 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 TestTestType in the ValidationType column.

TestUpdateUserId  :  int, allows null: no

An alias for the UpdateUserId column of the Tests table.

The ID of the user who last updated the test.

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

The title of the test.

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

The column is reserved for system use only.

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.

Version  :  int, allows null: no, default: 1

The version of the test.

See Also

TestSetItems Table
Test Management

Highlight search results