Folders Table

Applies to QAComplete 12.84 SaaS, last modified on July 19, 2021

Description

Contains created folders across all the projects.

Columns

The table contains the following columns:

FolderId  :  int, primary key, allows null: no

The unique numeric identifier of the folder.

DateCreated  :  datetime, allows null: no

Date and time when the folder 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

Date and time when the folder was last updated.

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

DeptId  :  int, allows null: yes

The ID of the department that owns the folder.

Description  :  varchar (max 1000 chars), allows null: yes

The description of the folder.

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

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

The module where the folder is located.

Correspondences between entity code values and related modules and features you can find in Table of Entity Code Values.

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

The name of the folder.

IsActive  :  char (max 1 char), allows null: no, default: Y

Shows if the folder is active.

IsPublic  :  char (max 1 char), allows null: no

The column is reserved for system use only.

IsVersion  :  char (max 1 char), allows null: no, default: N

The column is reserved for system use only.

OwnerUserId  :  int, allows null: no

The ID of the user who created the item.

ParentName  :  varchar (max 255 chars), allows null: yes, default:

The name of the folder’s parent. Otherwise it is NULL.

ProjId  :  int, allows null: no

The ID of the project that contains the folder.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

Folders View
Crossmodules

Highlight search results