Join Wintertainment 2021 to share your stories, have fun, earn community badges, and more!

TestRunItems View

Applies to QAComplete 12.94 SaaS, last modified on December 06, 2021

Description

Contains a detailed history of test runs.

Dependencies

Columns

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

The name of the test configuration.

DateFinished  :  datetime, allows null: yes

Date and time when the test run finished.

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

DateStarted  :  datetime, allows null: yes

The date and time when the test run started.

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

DateStarted  :  datetime, allows null: no

The date and time when the run started.

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

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

Indicates whether the test execution stops when the related 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 related test is tokenized, IterationCnt shows the total number of test iterations.

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.

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.

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

The status of the last test run.

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

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

ProjId  :  int, allows null: yes

The ID of the project that contains the item.

ReleaseId  :  int, allows null: yes

The ID of the related release, iteration or build.

ReleaseName  :  nvarchar (max 815 chars, or 1632 bytes), allows null: yes

The full name of the related release, iteration, or build.

RunByUserId  :  int, allows null: yes

The ID of the user who ran this test.

RunTime  :  int, allows null: yes

The time spent on executing the test run item, in seconds.

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

The time spent on executing the test run item, in the hh:mm:ss format.

Seq  :  int, allows null: no

The ordinal number of the test run item in the test run.

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

The status of the test run item (Passed, Failed, and so on).

TestConfigId  :  int, allows null: yes

The ID of the test configuration that was used for the test run.

TestDescription  :  nvarchar (max), allows null: yes

An alias for the Description column of the Tests table.

The description of the test.

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

TestId  :  int, allows null: yes

The ID of the related test.

TestName  :  nvarchar (max 167 chars, or 336 bytes), allows null: yes

The name of the related test. For tokenized tests, it contains information on test iterations.

TestRunId  :  int, allows null: no

The ID of the test run that contains the item.

TestRunItemId  :  int, allows null: no

The unique numeric identifier of the test run item.

TestSetId  :  int, allows null: yes

The ID of the related test set.

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

An alias for the Title column of the TestSets table.

The title of the test set.

Version  :  int, allows null: yes

The version of the related test.

See Also

TestRunItems Table
Test Management

Highlight search results