TestRuns Table

Applies to QAComplete 12.93 SaaS, last modified on November 01, 2021

Description

The table stores the history of test set runs.

Columns

The table contains the following columns:

TestRunId  :  int, primary key, allows null: no

The unique numeric identifier of the item.

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.

TestConfigId  :  int, allows null: yes

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

TestSetId  :  int, allows null: yes

The ID of the related test set.

Agents  :  nvarchar (max 2000 chars, or 4002 bytes), allows null: yes

Indicates the agent that was used for automated tests.

DateFinished  :  datetime, allows null: yes

The date and time when the 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: 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.

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

The type of the test run.

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

Indicates whether the test must be run in the order specified in the related test set.

NbrAwaitingRun  :  int, allows null: yes

The number of tests awaiting run.

NbrBlocked  :  int, allows null: yes

The number of tests that were blocked.

NbrFailed  :  int, allows null: yes

The number of failed tests.

NbrPassed  :  int, allows null: yes

The number of passed tests.

NbrTests  :  int, allows null: yes

The total number of tests in the related test set.

RunByHostId  :  int, allows null: yes

The ID of the test host used for automated tests.

RunByUserId  :  int, allows null: no

The ID of the user who performed the run.

RunTime  :  int, allows null: yes

The time it took to run the test set, in seconds.

ScheduleId  :  int, allows null: yes

The ID of the schedule that initiated the automated run.

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

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

See Also

TestRuns View
Test Management

Highlight search results