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.