TestRunItems Table

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

Description

Contains the history of test runs.

Columns

The table contains the following columns:

TestRunItemId  :  int, primary key, allows null: no

The unique numeric identifier of the test run item.

RunByHostId  :  int, allows null: yes

The ID of the test host used for automated tests.

TestRunId  :  int, allows null: no

The ID of the test run that contains the item.

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.

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

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

IterationCnt  :  int, allows null: yes

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

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.

Seq  :  int, allows null: no

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

SeqToken  :  int, allows null: yes

If the related test is tokenized, SeqToken represents the ordinal number of the run.

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

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

StatusUpdatedBy  :  int, allows null: yes

The ID of the user who updated the run status.

TestId  :  int, allows null: yes

The ID of the related test.

Version  :  int, allows null: yes

The version of the related test.

See Also

TestRunItems View
TestRunResults Table
Test Management

Highlight search results