Tests Table

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

Description

The table stores tests from the test library. The tests consist of multiple test steps from the TestSteps table in a one to many relationship.

Columns

The table contains the following columns:

TestId  :  int, primary key, allows null: no

The unique numeric identifier of the test.

DefaultHostId  :  int, allows null: yes, default: (NULL)

The ID of the host that is used as the default one for automated tests.

ProjId  :  int, allows null: no

The ID of the project that contains the test.

AssigneeUserId  :  int, allows null: yes

The ID of the user to whom the test is assigned.

CreateUserId  :  int, allows null: yes

The ID of the user who created the test.

Custom1..Custom10  :  nvarchar (max), allows null: yes

The values of custom fields 1 - 10.

These columns correspond to fields that can be available for rich editing.

DateCreated  :  datetime, allows null: no, default: Current date and time

The date and time the test was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: no, default: Current date and time

The date and time the test was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

Description  :  nvarchar (max), allows null: yes

The description of the test.

This column corresponds to a field that can be available for rich editing.

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

The type of the test run based on the choice list. The values of this choice list are stored in the Validation table. They correspond to the items whose values equal TestExecutionType in the ValidationType column.

FolderId  :  int, allows null: yes

The ID of the folder where the test is located.

ImportId  :  int, allows null: yes

The ID of the imported batch in which the test was imported.

IsActive  :  nvarchar (max 1 char, or 4 bytes), allows null: no, default: Y

Indicates whether the test is active.

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 test is tokenized, IterationCnt shows the total number of test iterations.

OriginalId  :  int, allows null: yes

The column is reserved for system use only.

OwnerUserId  :  int, allows null: yes

The ID of the user who owns the test.

Priority  :  nvarchar (max 100 chars, or 202 bytes), allows null: yes

The priority of the test based on the choice list. The values of this choice list are stored in the Validation table. They correspond to the items whose values equal TestPriority in the ValidationType column.

ScriptSourceId  :  int, allows null: yes

The column is reserved for system use only.

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

The status of the test based on the choice list. The values of this choice list are stored in the Validation table. They correspond to the items whose values equal TestStatus in the ValidationType column.

TestTokens  :  nvarchar (max 4000 chars, or 8002 bytes), allows null: yes

The column is reserved for system use only.

TestType  :  nvarchar (max 100 chars, or 202 bytes), allows null: yes

The type of the test based on the choice list. The values of this choice list are stored in the Validation table. They correspond to the items whose values equal TestTestType in the ValidationType column.

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

The title of the test.

TokenFileTitle  :  nvarchar (max 100 chars, or 202 bytes), allows null: yes

The column is reserved for system use only.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the test.

Version  :  int, allows null: no, default: 1

The version of the test.

See Also

Tests View
Test Management

Highlight search results