Bugs View

Applies to QAComplete 12.80 SaaS, last modified on April 20, 2021

Description

Contains detailed information on created defects.

Dependencies

Columns

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 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: no, default: 0

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

BugId  :  int, allows null: no

The unique numeric identifier of the item.

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

The ID of the user who closed the item.

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

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

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.

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.

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.

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

DestinationFastEditTitle  :  int, allows null: yes

The column was used in previous releases, and no longer used.

DestinationId  :  int, allows null: yes

The column was used in previous releases, and no longer used.

DestinationProject  :  int, allows null: yes

The column was used in previous releases, and no longer used.

DestinationProjId  :  int, allows null: yes

The column was used in previous releases, and no longer used.

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

FolderId  :  int, allows null: yes

The unique identifier 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.

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 Validations Table 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 Validations Table 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 Validations Table table. They correspond to the items whose values equal BugIssue in the ValidationType column.

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.

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 Validations Table table. They correspond to the items whose values equal BugModule in the ValidationType column.

NbrEscalations  :  int, allows null: no

The number of escalation rules affected to the defect.

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.

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

The ID of the user who created the defect.

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

An alias for the CompanyName column of the Persons table.

The name of the company where the user works.

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

An alias for the Email column of the Persons table.

The email address of the user.

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

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

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.

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 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 Validations Table table. They correspond to the items whose values equal BugPriority in the ValidationType column.

ProjId  :  int, allows null: no

The ID of the project that contains the defect.

Resolution  :  varchar (max), allows null: yes

The defect’s resolution details.

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

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 Validations Table 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.

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

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

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 Validations Table 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 Validations Table table. They correspond to the items whose values equal SoftwareVersion in the ValidationType column.

SourceFastEditTitle  :  int, allows null: yes

The column was used in previous releases, and no longer used.

SourceID  :  int, allows null: yes

The column was used in previous releases, and no longer used.

SourceProject  :  int, allows null: yes

The column was used in previous releases, and no longer used.

SourceProjId  :  int, allows null: yes

The column was used in previous releases, and no longer used.

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

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.

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

Bugs Table
Defects

Highlight search results