Lists View

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

Description

Contains detailed information on list items.

Dependencies

Columns

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.

DateCreated  :  datetime, allows null: yes, 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.

DateOpened  :  datetime, allows null: yes

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: yes, 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.

Field1..Field35  :  varchar (max 8000 chars), allows null: yes

Data in fields 1 through 35.

These columns correspond to fields 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).

ImportId  :  int, allows null: yes

The ID of the imported batch in which the list item was imported.

IsNewList  :  varchar (max 1 char), allows null: no, default: N

The column is reserved for system use only.

ListId  :  int, allows null: no

The unique numeric identifier of the item.

ListManagerId  :  int, allows null: yes

The ID of the related list.

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

List identifier: the name of the list without spaces.

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.

OpenedBy  :  int, allows null: yes

The ID of the user who created the item.

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

An alias for the CompanyName column of the Persons table.

The name of the company where the user works.

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

An alias for the Email column of the Persons table.

The email address of the user.

OpenedByName  :  varchar (max 78 chars), allows null: yes

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

OriginalId  :  int, allows null: yes

The column is reserved for system use only.

UpdateUserId  :  int, allows null: yes

The ID of the user who last updated the item.

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

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

See Also

Lists Table
Lists

Highlight search results