Bugs Table

Applies to QAComplete 12.71 SaaS, last modified on January 19, 2021

Description

Stores the defects reported in all the projects.

Columns

The table contains the following columns:

BugId  :  int, primary key, allows null: no

The unique numeric identifier of the item.

ProjId  :  int, allows null: no

The ID of the project that contains the defect.

ActFinish  :  datetime, allows null: yes

The date when the defect was fixed.

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 to fix the defect.

ActStart  :  datetime, allows null: yes

The date when the work on fixing the defect 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 reproduction steps as compared to the expected results.

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

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

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

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

The ID of the user who closed the item.

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 editing.

DateClosed  :  datetime, allows null: yes

The date and time the defect was closed.

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

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

The date and time the item was created.

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

The date and time the defect was opened.

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

DateResolved  :  datetime, allows null: yes

The date and time the defect was resolved.

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 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  :  varchar (max), allows null: yes

The defect’s description.

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

EstFinish  :  datetime, allows null: yes

The date and time the work on the defect 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 the defect will take to resolve, in hours.

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

The estimated number of hours remaining to fix the defect.

EstStart  :  datetime, allows null: yes

The date and time the work on the defect 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 software results, if there were no this defect.

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

FolderId  :  int, allows null: yes

The unique identifier of the folder where the item is located.

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

The functional area related to the defect. The code of the functional area is taken from the choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal FunctionalArea in the ValidationType column.

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

Information on how the defect was found based on the choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal BugHowFound in the ValidationType column.

ImportId  :  int, allows null: yes

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

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

The issue code based on the choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal BugIssue in the ValidationType column.

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

The module related to the defect. The code of the module is taken from the choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal BugModule in the ValidationType column.

OpenedBy  :  int, allows null: no, default: 0

The ID of the user who created the defect.

OriginalId  :  int, allows null: yes

The column is reserved for system use only.

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

The column is reserved for system use only.

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

The ID of the user who owns the defect.

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

The percentage of work completed to fix the defect.

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

PriorityCode  :  varchar (max 100 chars), allows null: yes, default:

The defect’s priority based on the choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal BugPriority in the ValidationType column.

Resolution  :  varchar (max), allows null: yes

The defect’s resolution details.

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

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

The resolution code based on the choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal BugResolution in the ValidationType column.

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

The ID of the user who resolved the item.

SeverityCode  :  varchar (max 100 chars), allows null: yes, default:

The severity of the defect based on the choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal BugSeverity in the ValidationType column.

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

The software version that relates to the defect. The code of the version is taken from the choice list. The values of the choice list are stored in the Validation table. They correspond to the items whose values equal SoftwareVersion in the ValidationType column.

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

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

StepsToRepro  :  varchar (max), allows null: yes

The steps to reproduce the defect.

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

TestCaseId  :  int, allows null: yes

If the defect was created from a failed legacy test case, TestCaseId is the unique identifier of the related test case.

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

The title of the defect.

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

The column is reserved for system use only.

UpdateUserId  :  int, allows null: yes

The ID of the user who last updated the item.

See Also

Bugs View
Defects

Highlight search results