TestVersionHistory View

Applies to QAComplete 12.70 SaaS, last modified on January 11, 2021

Description

Contains detailed information on the previous test versions.

Dependencies

Columns

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

Indicates whether the test version can be deleted. It is possible to do this when there is no run history related to this test version.

AssigneeUserId  :  int, allows null: yes

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

AvgRunTime  :  int, allows null: no

The average run time of this test version, in seconds.

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

The average run time of this test version, in the hh:mm:ss format.

CreateUserId  :  int, allows null: yes

The ID of the user who created the test.

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

The values of custom fields 1 - 90.

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

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

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.

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, default: Current date and time

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

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 version 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 version resides.

FolderName  :  varchar (max 255 chars), allows null: no

The name of the folder.

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, default: Y

Indicates whether the test version is active.

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

Indicates whether the test version is currently used.

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

The column is reserved for system use only.

IterationCnt  :  int, allows null: no

The column is reserved for system use only.

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: no

The ID of the user who last ran this test version.

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.

LastRunReleaseId  :  int, allows null: no

The ID of the release that was last used to run the test version.

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: no

The status of the last test version run.

LastRunTestConfigId  :  int, allows null: no

The ID of the configuration used for the last test version 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: no

The ID of the test set in which this test version was 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 this test version.

NbrEvents  :  int, allows null: no

The number of events attached to this test version.

NbrFailStatus  :  int, allows null: no

The number of times this test version failed.

NbrFiles  :  int, allows null: no

The number of files attached to the this test version.

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 this test version.

NbrPassStatus  :  int, allows null: no

The number of times this test version passed.

NbrSteps  :  int, allows null: yes

The number of steps in this test version.

NbrTestRuns  :  int, allows null: yes

The number of runs of this test version.

NbrTimesRun  :  int, allows null: no

The number of times this test version 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 test version, in the Last name, First name format.

OwnerUserId  :  int, allows null: yes

The ID of the user who owns the test version.

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

The priority of the test version 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.

ScriptName  :  nvarchar (max), allows null: no

The column is reserved for system use only.

ScriptSourceId  :  int, allows null: yes

The column is reserved for system use only.

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

The status of the test version 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.

TestId  :  int, allows null: no

The ID of the related test.

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

The column is reserved for system use only.

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

The type of the test version 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.

TestVersionHistoryId  :  int, allows null: no

The unique numeric identifier of the item.

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

The title of the test version.

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

The column is reserved for system use only.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the test version.

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

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

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

The version of the test.

See Also

TestVersionHistory Table
Test Management

Highlight search results