TestStats Table

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

Description

The table stores the statistics of test sets.

Columns

The table contains the following columns:

FKID  :  int, allows null: no

The ID of the related test.

AvgRunTime  :  int, allows null: yes

The test’s average run time, in seconds.

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

The ID of the user who last ran the test.

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

The ID of the release that was last used in the test.

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

The status of the last test run.

LastRunTestConfigId  :  int, allows null: yes

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

The ID of the test set used for the 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.

NbrFailStatus  :  int, allows null: yes

The number of times the test failed.

NbrPassStatus  :  int, allows null: yes

The number of times the test passed.

NbrSteps  :  int, allows null: yes

The number of steps in the test.

NbrTimesRun  :  int, allows null: yes

The number of times the test was run.

ScriptName  :  nvarchar (max 255 chars, or 512 bytes), allows null: yes

The column is reserved for system use only.

ScriptSourceId  :  int, allows null: yes

The column is reserved for system use only.

See Also

TestStatsByReleases View
Test Management

Highlight search results