Forums View

Applies to QAComplete 12.71 SaaS, last modified on January 18, 2021

Description

Contains detailed information on the created forums.

Dependencies

Columns

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

The type of the application. agSP corresponds to QAComplete SaaS, and agSPEnt corresponds to QAComplete On-Premises.

CategoryCode  :  varchar (max 100 chars), allows null: yes

The column is reserved for system use only.

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

The ID of the department that owns the forum.

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

The description of the forum.

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

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

The email address of the forum’s moderator.

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

The column is reserved for system use only.

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

The column is reserved for system use only.

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

The column is reserved for system use only.

ForumId  :  int, allows null: no

The unique numeric identifier of the forum.

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

The name of the forum.

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

Indicates whether the forum is active.

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

Indicates whether the forum is company wide.

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

Indicates whether the forum is public.

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

The identifier of the project that contains the forum. If the forum is company wide, the ID is 0.

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

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

Forums Table
Collaboration

Highlight search results