Join Wintertainment 2021 to share your stories, have fun, earn community badges, and more!

Releases Table

Applies to QAComplete 12.94 SaaS, last modified on December 06, 2021

Description

The table stores release details from all the projects.

Columns

The table contains the following columns:

Id  :  int, primary key, allows null: no, default: auto generated

The unique numeric identifier of the item.

ParentId  :  int, allows null: yes

The ID of the item’s parent release or iteration.

ProjId  :  int, allows null: no, default: auto filled

The ID of the project that contains the item.

ReleaseId  :  int, allows null: yes

The ID of the top level release in the hierarchy.

AssigneeUserId  :  int, allows null: yes

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

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

DateCreated  :  datetime, allows null: no

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

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

EstFinishDate  :  datetime, allows null: yes

The date the work on the item is estimated to complete.

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

EstStartDate  :  datetime, allows null: yes

The date the work on the item 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.

FolderId  :  int, allows null: yes, default: auto filled

The ID of the folder where the item is located.

ImportId  :  int, allows null: yes

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

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

Indicates whether the item is active.

IsAutoAdjustEstDates  :  nvarchar (max 1 char, or 4 bytes), allows null: no

Indicates whether the estimated start and finish dates are adjusted automatically.

OwnerUserId  :  int, allows null: yes

The ID of the user who created the item.

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

The type of the item (Release, Iteration, or Build).

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

The ordinal number of the item among its siblings.

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

The status of the item 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 ReleaseStatus in the ValidationType column.

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

The title of the release.

UpdateUserId  :  int, allows null: yes

The ID of the user who last updated the item.

See Also

ReleaseStats Table
Releases

Highlight search results