TestConfigurations View

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

Description

Contains detailed information on the test configurations.

Dependencies

Columns

ConfigId  :  int, allows null: no

The unique numeric identifier of the item.

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

The name of the test configuration.

CreateUserId  :  int, allows null: yes

The ID of the user who created the item.

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 Text Feature.

Custom11..Custom90  :  varchar (max 100 chars), allows null: yes

The values of custom fields 11 through 90.

DateCreated  :  datetime, allows null: no

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

This column corresponds to a field that can be available for Rich Text Feature.

FolderId  :  int, allows null: yes

The ID of the folder where the item is located.

FolderName  :  varchar (max 511 chars), allows null: yes

The name of the folder where the associated item is located.

ImportId  :  int, allows null: yes

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

IsActive  :  nvarchar (max 1 char, or 4 bytes), allows null: yes

Indicates whether the configuration is active.

NbrFiles  :  int, allows null: yes

The number of files attached to the associated item.

NbrFilesNotSecured  :  int, allows null: yes

The column is reserved for system use only.

NbrNotes  :  int, allows null: yes

The number of notes attached to the associated item.

NotesDescription  :  varchar (max), allows null: yes

An alias for the LatestNotes column of the ExtendedAttributes table.

A description of the latest note attached to the associated item.

OriginalId  :  int, allows null: yes

The column is reserved for system use only.

OwnerName  :  varchar (max 78 chars), allows null: yes

The name of the user who owns the associated item, in the Last name, First name format.

OwnerUserId  :  int, allows null: no

The ID of the user who owns the test configuration.

ProjId  :  int, allows null: yes

The ID of the project that contains the item.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

UserName  :  varchar (max 78 chars), allows null: yes

The name of the user who last updated the associated item, in the Last name, First name format.

See Also

TestConfigurations Table
TestRunItems View
Test Management

Highlight search results