TestRuns View

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

Description

The TestRuns view contains a detailed history of test set runs.

Dependencies

Columns

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

Indicates the agent that was used for automated tests.

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

The name of the test configuration.

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.

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.

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.

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

RunTime  :  int, allows null: yes

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

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

The time it took to run the test set, in the hh:mm:ss format.

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).

TestConfigId  :  int, allows null: yes

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

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

An alias for the HostName column of the TestHosts table.

The name of the test host.

TestRunId  :  int, allows null: no

The unique numeric identifier of the 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.

See Also

TestRuns Table
Test Management

Highlight search results