Folders View

Applies to QAComplete 12.90 SaaS & On-Premises, last modified on September 09, 2021

Description

Contains detailed information on folders.

Dependencies

Columns

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

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.

FolderId  :  int, allows null: no

The unique numeric identifier of the folder.

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

The name of the folder.

FullFolderName  :  varchar (max 511 chars), allows null: yes

A combination of the parent folder’s name and the name of the folder itself.

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

Shows if the folder is active.

IsCompanyWide  :  varchar (max 1 char), allows null: no

Indicates whether the folder is available in all the projects.

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.

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.

OwnerUserId  :  int, allows null: no

The ID of the user who created the item.

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

The name of the user who created the folder.

ParentId  :  int, allows null: no

The ID of the parent folder.

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.

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

The name of the user who last updated the folder.

See Also

Folders Table
Crossmodules

Highlight search results