ListManager View

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

Description

Contains detailed information on created lists across all the projects.

Dependencies

Columns

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

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

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

The column is reserved for system use only.

DateCreated  :  datetime, allows null: no, default: Current date and time

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

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

The description of the list.

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

GroupId  :  int, allows null: yes, default: 0

The ID of the related department or project. Depends on the GroupType value.

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

Shows the type of the group identifier (DeptId or ProjId).

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

The caption of the list.

ListDataSeparatedBy  :  varchar (max 15 chars), allows null: yes, default: Company

Shows if the list is company-wide or project-specific. CompanyWide means that the list items are available in all projects, ProjectSpecific means that the list contains different data for different projects.

ListManagerId  :  int, allows null: no

The unique numeric identifier of the item.

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

The name of the list.

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

List identifier: the name of the list without spaces.

ListVisibility  :  varchar (max 15 chars), allows null: yes, default: ThisClientOnly

The column is reserved for system use only.

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

The ID of the user who last updated the item.

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

The name of the person who last updated the item, in the Last name, First name format.

See Also

ListManager Table
Lists View
Lists

Highlight search results