ListManager Table

Applies to QAComplete 12.75 SaaS, last modified on April 01, 2021

Description

The ListManager table holds list definitions. The definition of the fields on a list are stored on the Grids table.

Columns

The table contains the following columns:

ListManagerId  :  int, primary key, allows null: no

The unique numeric identifier of the item.

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

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

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.

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 View
Lists Table
Lists

Highlight search results