TestCases View

Applies to QAComplete 12.75 SaaS, last modified on April 01, 2021

Description

Contains detailed information on test cases.

Dependencies

Columns

ActFinish  :  datetime, allows null: yes

The date when the work on the test case actually completed.

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

ActHrs  :  decimal (max 18 decimal digits), allows null: yes, default: 0

The actual number of hours spent on the task.

ActStart  :  datetime, allows null: yes

The date when the work on the test case actually started.

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

ActualResults  :  varchar (max), allows null: yes

The actual results of performing the steps as compared to the expected results.

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

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

The name of the user to whom the associated item is assigned, in the Last name, First name format.

AssigneeUserId  :  int, allows null: yes, default: 0

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

AutomationScriptUNC  :  varchar (max 255 chars), allows null: yes

The column is reserved for system use only.

Custom1..Custom10  :  varchar (max 8000 chars), 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, default: Current date and time

The date and time when the test case was created.

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

DateLastEscalated  :  datetime, allows null: yes

The date when the associated item was last affected by an escalation rule.

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.

DefectId  :  int, allows null: yes

This column is not used.

EstFinish  :  datetime, allows null: yes

The date and time the work on the test case is estimated to finish.

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

EstHrs  :  decimal (max 18 decimal digits), allows null: yes, default: 0

The estimated time needed to finish the test case, in hours.

EstHrsRemaining  :  decimal (max 18 decimal digits), allows null: yes, default: 0

The estimated number of hours remaining to finish the work on the test case.

EstStart  :  datetime, allows null: yes

The date and time the work on the test case is estimated to start.

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

ExpectedResults  :  varchar (max), allows null: yes

The expected results of performing the steps.

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.

FunctSpecId  :  int, allows null: yes

This column is not used.

FunctSpecTitle  :  varchar (max 255 chars), allows null: no

An alias for the Title column of the FunctionalSpecs table.

The title of the requirement.

Grouping  :  varchar (max 50 chars), allows null: yes

The group that contains the test case. Group names are specified in a choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal TCGroup in the ValidationType column.

ImportId  :  int, allows null: yes

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

Keywords  :  varchar (max 200 chars), allows null: yes

The keywords associated with the test case.

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

The name of the escalation rule that last affected the associated item.

LastEscalationRuleId  :  int, allows null: yes

The ID of the escalation rule that last affected the associated item.

NbrEscalations  :  int, allows null: no

The number of times an escalation rule affected the test case.

NbrEvents  :  int, allows null: yes

The number of events attached to the associated item.

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.

NbrTasks  :  int, allows null: yes

The number of tasks 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: yes, default: 0

The ID of the user who created the item.

PctComplete  :  tinyint, allows null: yes, default: 0

Ther percentage of test case completion.

QAComplete calculates this value automatically when the user specifies how many hours have been spent on that task. To learn more, see Calculation of Percent Complete and Estimated Hours Remaining.

ProjId  :  int, allows null: no

The ID of the project that contains the test case.

StatusCode  :  varchar (max 100 chars), allows null: no

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

Steps  :  varchar (max), allows null: yes

The steps to be performed in the test case.

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

SubGrouping  :  varchar (max 50 chars), allows null: yes

The subgroup that contains the test case. Subgroup names are specified in a choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal TCSubGroup in the ValidationType column.

TestCaseId  :  int, allows null: no

The unique numeric identifier of the test case.

Title  :  varchar (max 100 chars), allows null: no

The title of the test case.

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

TestCases Table
Legacy Test Management

Highlight search results