FileExchanges View

Applies to QAComplete 12.70 SaaS, last modified on January 11, 2021

Description

The view contains detailed information on the shared files and documents.

Dependencies

Columns

CheckedOutBy  :  int, allows null: yes

If locked, the ID of the user who locked the item.

CheckedOutByFirstLastName  :  varchar (max 51 chars), allows null: no

The name of the user who locked the item, in the <First name> <Last name> format.

CheckedOutByName  :  varchar (max 78 chars), allows null: no

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

CompanyId  :  int, allows null: no

The column is reserved for system use only.

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.

DateCheckedOut  :  datetime, allows null: yes

If locked, the date the item was checked out.

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: no, default: Current date and time

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

DeptId  :  int, allows null: no

The ID of the department that owns the file.

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

The description of the shared file or document.

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

FASTCommunityId  :  char (max 5 chars), allows null: yes

The column is reserved for system use only.

FASTProjId  :  char (max 5 chars), allows null: yes

The column is reserved for system use only.

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

The type of the shared file (Text, ZIP, and so on).

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

The file name of the shared document.

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

The name of the zipped version of the file, as stored on the server.

FileSize  :  varchar (max 15 chars), allows null: yes, default: 0KB

The size of the shared file or document.

FolderId  :  int, allows null: yes

The identifier of the folder where the item resides.

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

The name of the folder.

Grouping  :  varchar (max 50 chars), allows null: no

The group that contains the item. Group names are specified in a choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal FEGroup in the ValidationType column.

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

The column is reserved for system use only.

IsRemote  :  char (max 1 char), allows null: yes, default: N

The column is reserved for system use only.

Keywords  :  varchar (max 200 chars), allows null: yes

A list of keywords used to search for the item.

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.

NbrNotes  :  int, allows null: yes

The number of notes 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.

ProjId  :  int, allows null: yes

The identifier of the project that contains the item.

ProjName  :  varchar (max 50 chars), allows null: no

The name of the project.

ShowDocsTo  :  varchar (max 30 chars), allows null: yes

The column is reserved for system use only.

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

The status of the document (Final or Preliminary).

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

The subgroup that contains the item. Subgroups are specified in a choice list. The values of the choice list are stored in the Validations Table table. They correspond to the items whose values equal FESubgroup in the ValidationType column.

ThumbnailId  :  int, allows null: no

An alias for the FileId column of the FileExchanges table.

The unique numeric identifier of the item.

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

The title of the item.

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 associated item, in the Last name, First name format.

See Also

FileExchanges Table
Forums Table
Collaboration

Highlight search results