Description
Contains a detailed history of test runs.
Dependencies
- Attachments table
- Persons view
- TestConfigurations table
- TestHosts table
- TestRunItems table
- TestRuns table
- TestRuns view
- Tests table
- TestSets table
- TestStats table
- TestVersionHistory view
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.